You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-02-15 00:35:11

bluEra
Member
8 posts

bluEra said:

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

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. smile

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

Last edited by bluEra (2017-02-15 00:38:36)

Offline

#2 2017-02-15 02:11:07

bluEra
Member
8 posts

bluEra said:

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

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

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy