[resolved] Combining different schema with multiple rows into one output

[Anonymous]

Hi,
I gladly appreciate if someone can help me find a solution that can just append columns into one output. Both source have one same column that can be used as link to each other. No transformation needed just pure mapping. Thanks in advance.

Source 1:
Col A | Col B 
ID 1  | Data 1
ID 1  | Data 2
ID 1  | Data 3
ID 2  | null
ID 3  | null

Source 2:
Col A | Col C
ID 1  | Info 1
ID 1  | Info 2
ID 2  | Info 1

Desired Output:
Col A | Col B   | Col C
ID 1  | Data 1 | Info 1
ID 1  | Data 2 | Info 2
ID 1  | Data 3 | null
ID 2  | null     | Info 1
ID 3  | null     | null

[Anonymous]

Got the solution. Let me know if anyone is having trouble on this kind of scenario.