CODEWITHSUNDEEP
etldata-warehousetalenddata-integration
Kaushal
Kaushal

Reputation: 938

Talend: Handle order of columns

I am designing a job in Talend (ETL Tool). The incoming Data may have columns in different order.

How do I handle this? I want to map them to a static target (I am using tMap for this). Also, I need to take care of number of columns(it may be less or more than what is expected)

Upvotes: 1

Views: 1321

Answers (2)

garpitmzn
garpitmzn

Reputation: 1011

tFilterColumn can be used for filter columns flow from one component to another. Even tmap itself is a good way to control number of columns in output table of tmap.

Upvotes: 0

localhost
localhost

Reputation: 89

check this tutorial. It works perfectly:

http://bekwam.blogspot.de/2011/06/dynamic-schemas-in-talend-open-studio.html

Upvotes: 1

Related Questions