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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ashc_cool10
Helper III
Helper III

Create differentiator for common column in new table

Hi Team,

 

I am trying to create one table in which data is coming from two different tables : "Table 1" & "Table 2"  which contains one common column called"MATNR" . I need to create a differentiater in a new table(Table 3) in which i need to know if i have "MATNR" number then from which table its appearing in Table 3 :
Please see below for more clarification in the excel.

Request you to please help me in acheving this .

 

Capture_2.JPG

 Regards,

Ashish

 

1 ACCEPTED SOLUTION

Hi @v-yiruan-msft ,

 

Thank you for your response . This has been sorted now .

 

Regards,

Ashish

View solution in original post

2 REPLIES 2
v-yiruan-msft
Community Support
Community Support

Hi @ashc_cool10 ,

Thanks for reaching out to us with your requirement. It seems that you want to get a table base on the table "Table1" and "Table2". But what's the backend logic? For example: Matnr 123, why the return key is 334 not 344? Could you please explain it with more details(specific example, screenshot etc.)? It would be helpful to find the solution. Thank you.

vyiruanmsft_0-1702031796033.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yiruan-msft ,

 

Thank you for your response . This has been sorted now .

 

Regards,

Ashish

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.