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 

[Khushboosharma391]

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

[Yoshiro_Fujimori]

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

ID

Node Name

City1

Country1

Child1

City2

Country2

Child2

City3

Country3

Child3

City4

Country4

Child4

City5

Country5

Child5

City6

Country6

1

A1

Tokyo

Japan

B1

Paris

France

C1

New York City

USA

X1

City X1

Country X1

Y1

City Y1

Country Y1

2

A1

Tokyo

Japan

B2

London

United Kingdom

C2

Beijing

China

X2

City X2

Country X2

Y2

City Y2

Country Y2

3

A1

Tokyo

Japan

B3

Moscow

Russia

C3

Sydney

Australia

X3

City X3

Country X3

4

P1

Cairo

Egypt

Q1

Rio de Janeiro

Brazil

R1

Berlin

Germany

Z1

City Z1

Country Z1

5

P1

Cairo

Egypt

Q2

Istanbul

Turkey

R2

Toronto

Canada

6

P1

Cairo

Egypt

Q3

Mumbai

India

R3

Mexico City

Mexico