thanks for sharing group by feature in elasticsearch. I am wondering if this transform works well for consolidating data from multiple tables.

for example:

table 1: {userid, name}

table 2: (userid, income}

I want to use same aggregated index for both table by using userid as groupby. Will be transformed index keep both name and income?