Create differentiator for common column in new table

[ashc_cool10]

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 .

 Regards,

Ashish

[v-yiruan-msft]

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.

Best Regards

[ashc_cool10 · Accepted solution]

Hi @v-yiruan-msft ,

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

Regards,

Ashish