Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 .

 

 Regards,

Ashish

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

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

     

    Regards,

    Ashish

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

       

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

       

      Regards,

      Ashish