One Star

Dynamic schema

Hi,
i have a 3 feed file which has 5 columns(name,age,sex,phno,dept) with 100 rows.The columns names are not sequentially arranged in all the feed file.
Now while reading i only want to read 3 columns ( name,age ,dept) but not using TMap.
As the columns names are not sequentially arranged , i want to read the rows by reading the column names.
how I can achieve that ?
regards,
romi
2 REPLIES
Moderator

Re: Dynamic schema

Hi,
It seems you are looking for dynamic schema feature in talend which allows you to design schema with an unknown column structure (unknown name and number of columns), however, dynamic schema feature is only available in Talend Enterprise Subcription Version.
Please have a look at the KB artcile TalendHelpCenter:How to process changing data structure?.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seventeen Stars

Re: Dynamic schema

You could use the component tFileInputTextFlat from Talend Exchange to do that. This component provides a method to set the position of a column by its header line (also find the column by regex expressions).
http://www.talendforge.org/exchange/index.php?eid=745&product=tos&action=view&nav=1,1,1
You will find here a documentation and a link to the install description from Talend for User Components.