Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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