You are not logged in.
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?
Does the tUnite compoent fit your need?
Please show detailed information about your data source? file or database?
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:
How can I do?
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.
Edit: The expressions looking like ro... in the screenshot are row1.ID, row1.INFO, row2.INFO and row3.INFO
Last edited by Theo (2008-05-13 15:17:00)