Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dandamudisanjay
Regular Visitor

MergingQueriesbeforeRelationships

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

1 ACCEPTED SOLUTION

Hi @dandamudisanjay ,

 

You can do it:

Capture.PNG

 

After, just drop the File2 Column.

 

If you consider it as a solution, please mark as a solution and kudos.

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
dandamudisanjay
Regular Visitor

 

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:

Capture.PNG

 

After, just drop the File2 Column.

 

If you consider it as a solution, please mark as a solution and kudos.

Ricardo



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors