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.
Hi All,
I'm looking to merge query without duplicates and failing miserably. Could you please help?
table 1 contains ID and table 2 contains same ID but can contain multiple times.
Output what i'm wanting is only to see table 1 data where table1.ID is also present in table2.ID without any duplicate rows.
Any help with this is greatly appreciated.
Regards
Sanjay
Solved! Go to Solution.
Hi @dandamudisanjay ,
You can do it:
After, just drop the File2 Column.
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
File 1
ID | NAme |
1 | a |
2 | b |
3 | c |
4 | d |
5 | e |
File 2
Transaction ID | ID | Total |
2345 | 1 | 5 |
13343 | 2 | 10 |
5656 | 3 | 15 |
2345 | 1 | 100 |
13343 | 2 | 232 |
909 | 2 | 876
|
Output
ID | Name |
1 | a |
2 | b |
3 | c |
Hi @dandamudisanjay ,
You can do it:
After, just drop the File2 Column.
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
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.