Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Guys,
I have two tables which are related to each other but number of rows are different.
Table 1 :
This table has multiple rows with campaign and adgroup combinations. And I have table 2 which has columns device,search engine,advertising type,language,location,primarylist and target value.
I want to distribute value from table 2 to table 1. For example : first row in table 2 represents for AUS, EN, GO,SER,Desktop,BLK and 01/01/2018 we have target value as 2605.71 and for the same combination in table1 we have 3 rows (top 3 rows) and I want each row in table 1 to have target value which will be 2605.71/3 = 868.57.
@Anonymous,
You may refer to the following post.
I understand the solution that you have shared but the problem is I have different other filters as well. How do i match those values from table 2 to table 1?