Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i am trying to merge two tables using INNER JOIN but am getting duplicate rows.
This is my data " https://www.dropbox.com/s/2wk5tk455w5332p/Data.xlsx?dl=0 "
am trying to merge these two tables based on these columns: UNIT,LOC,DATE,MATCH BD from Table 1
and UNIT,LOC,DATE,MATCH ID from Table 2
My final table after merging should be like this: UNIT, GROUP,LOC,PR,DATE,BD,BD Value, MATCH BD, ID, ID value.
Any help on this Please. Thanks in Advance.
Hi @yodha
add merge columns in Table1 and Table2,
(merge columns UNIT,LOC,DATE,MATCH BD to one column)
merge queries for Table1 and Table2 based on" merged1" and "merged2" columns.
select ID, ID value by expanding the "Table2" field
Hi @yodha
Do you download my pbix to see each step?
Or could you share the pbix with me for further analysis?
Any help on this?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |