How to join two tables

[Ashwin_99]

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 Name	City	Country
A1	Tokyo	Japan
B1	Paris	France
C1	New York City	USA
B2	London	United Kingdom
C2	Beijing	China
B3	Moscow	Russia
C3	Sydney	Australia
P1	Cairo	Egypt
Q1	Rio de Janeiro	Brazil
Q2	Istanbul	Turkey
Q3	Mumbai	India
R1	Berlin	Germany
R2	Toronto	Canada
R3	Mexico City	Mexico

Table 2:

ID	Node Name	Child 1	Child 2
1	A1	B1	C1
2	A1	B2	C2
3	A1	B3	C3
4	P1	Q1	R1
5	P1	Q2	R2
6	P1	Q3	R3

Expected Output:

ID	Node Name	City1	Country1	Child 1	City2	Country2	Child 2	City3	Country3
1	A1	Tokyo	Japan	B1	Paris	France	C1	New York City	USA
2	A1	Tokyo	Japan	B2	London	United Kingdom	C2	Beijing	China
3	A1	Tokyo	Japan	B3	Moscow	Russia	C3	Sydney	Australia
4	P1	Cairo	Egypt	Q1	Rio de Janeiro	Brazil	R1	Berlin	Germany
5	P1	Cairo	Egypt	Q2	Istanbul	Turkey	R2	Toronto	Canada
6	P1	Cairo	Egypt	Q3	Mumbai	India	R3	Mexico City	Mexico

Thanks in advance,

Regards,

Ashwin_99

[TimN]

Maybe something like this...

[Khushboosharma391]

Hello, tried to make your workflow, hope this helps you. 

[Ashwin_99]

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