How to join two tables

Question

Hi All,

I need a help in pulling the information from one table to another table.

here is my 2 input tables.

Table 1:

Node NameCityCountryA1TokyoJapanB1ParisFranceC1New York CityUSAB2LondonUnited KingdomC2BeijingChinaB3MoscowRussiaC3SydneyAustraliaP1CairoEgyptQ1Rio de JaneiroBrazilQ2IstanbulTurkeyQ3MumbaiIndiaR1BerlinGermanyR2TorontoCanadaR3Mexico CityMexico

Table 2:

IDNode NameChild 1Child 21A1B1C12A1B2C23A1B3C34P1Q1R15P1Q2R26P1Q3R3

Expected Output:

IDNode NameCity1Country1Child 1City2Country2Child 2City3Country31A1TokyoJapanB1ParisFranceC1New York CityUSA2A1TokyoJapanB2LondonUnited KingdomC2BeijingChina3A1TokyoJapanB3MoscowRussiaC3SydneyAustralia4P1CairoEgyptQ1Rio de JaneiroBrazilR1BerlinGermany5P1CairoEgyptQ2IstanbulTurkeyR2TorontoCanada6P1CairoEgyptQ3MumbaiIndiaR3Mexico CityMexico

Thanks in advance,

Regards,

Ashwin_99

Yoshiro_Fujimori · Answer

Hi @Ashwin_99 ,

I tried to make it dynamic.

I hope this helps.

The field names were a bit tricky as the same seq number does not always related to the same node.

You can modify the formula tool to adjust field names as you like.

Workflow

Output

IDNode NameCity1Country1Child1City2Country2Child2City3Country3Child3City4Country4Child4City5Country5Child5City6Country61A1TokyoJapanB1ParisFranceC1New York CityUSAX1City X1Country X1Y1City Y1Country Y1   2A1TokyoJapanB2LondonUnited KingdomC2BeijingChinaX2City X2Country X2Y2City Y2Country Y2   3A1TokyoJapanB3MoscowRussiaC3SydneyAustraliaX3City X3Country X3      4P1CairoEgyptQ1Rio de JaneiroBrazilR1BerlinGermany      Z1City Z1Country Z15P1CairoEgyptQ2IstanbulTurkeyR2TorontoCanada         6P1CairoEgyptQ3MumbaiIndiaR3Mexico CityMexico

1262787.yxmd

Khushboosharma391 · Answer

yes we can make it dynamic; do you want me to create that or just need the overview how we can make it

Ashwin_99 · Answer

Hii Folks,

Thank you for your response it was really helpful,

But i have a question, if in case we have children more than 2 then i dont this this workflow will run,

Can we make it dynamic to handle the issue when we get more than 2 childs

Thanks

Happy learning.

Regards

Ash