-
1. Re: joining 2 tables with different levels of aggregation
Kalyan Allam Feb 6, 2019 12:20 AM (in response to Jhanvi Hegde)1 of 1 people found this helpfulyou can actually use blending here. Bring Profit as primary data source and Edit the Relationships and make ID as the linking field.
I am suggesting blending because joins in your case will duplicate the amounts and you will have issues in bringing the correct amounts.
-
2. Re: joining 2 tables with different levels of aggregation
Jhanvi Hegde Feb 6, 2019 12:32 AM (in response to Kalyan Allam)Thanks Kalyan.
yes I am getting sum of duplicate amounts. Can you please show how to do blending? Thanks.
-
3. Re: joining 2 tables with different levels of aggregation
Vaishnavi krishnan Feb 6, 2019 12:47 AM (in response to Jhanvi Hegde)1 of 1 people found this helpful -
4. Re: joining 2 tables with different levels of aggregation
Zhouyi ZhangFeb 6, 2019 4:36 AM (in response to Jhanvi Hegde)
Hi, Jhanvi
Here is another way of using join as shown below by key id =id
And then for sales, use sum as aggregation, and for profit, use average as aggregation
Workbook attached.
Hope this helps
ZZ
-
Book1_v10.2.twbx 19.8 KB
-
-
5. Re: joining 2 tables with different levels of aggregation
Jhanvi Hegde Feb 6, 2019 4:29 PM (in response to Zhouyi Zhang)Hi Zhouyi,
Thank you. you are using a join and not blending? Also,why
a left join and not a inner join?
Thank you!
-
6. Re: joining 2 tables with different levels of aggregation
Zhouyi ZhangFeb 6, 2019 8:53 PM (in response to Jhanvi Hegde)
Hi, Jhanvi
It is a data join, not blend. and using which type of join will depend on your demand, they all should work.
ZZ