How can I combine columns?

[Anonymous]

Hi,
I have several shemas with two columns, one columns is the id, the other one is the information concerned to the id. Now, I want to combine these shemas as one shema with one column of id and other columns with information concerned. How can I do?
Thank you!

[Anonymous]

Hello
Does the tUnite compoent fit your need?
Please show detailed information about your data source? file or database?
Best regards

shong

[Anonymous]

Hi,
For exemples, I want to get the result like this:
file1 file 2 file3
ID;INFOR1 ID;INFOR2 ID;INFOR3
1;dd 1;11 1;dfff
2;df 2;22 2;uyyy
3;cc 3;33 3;hnnn
4;wa 4;44 4;hppp
5;fe 5;55 5;fooo

Now I want to get a unique file:
ID;INFOR1;INFOR2;INFOR3
1;dd;11;dfff
2;df;22;uyyy
3;cc;33;hnnn
4;wa;44;hppp
5;fe;55;fooo
How can I do?
thanks

[_AnonymousUser]

Hello,
I would do it this way:
- Use three tFileInputDelimited (one for each file), define the schemas as "ID" and "INFO"
- Use a tMap and connect it with all file inputs. Set up the schema and expressions like in the screenshot below
I hope this was helpful for you.
Regards,
Theo
Edit: The expressions looking like ro... in the screenshot are row1.ID, row1.INFO, row2.INFO and row3.INFO

[Anonymous]

I hope this was helpful for you.

Yes it does help me, Thanks a lot Theo!