I am having a problem with a dynamic schema. I am using a tFileInputDelimited to read in a pipe delimited file as a dynamic input row of width 255. However, this file includes a column with header “License #” (without the quotes). Normally, Talend changes this header to “License__”. I then follow the tFileInputDelimited with an tExtractDynamicFields with a schema of the expected header names including “License__” . I then use a tLogRow to list out the output of the tExtractDynamicFields and get data for every column except “License__”. I have tried adjusting the number of underscores and even added a number with no success. Has anyone run into this problem and knows what tExtractDynamicFields is looking for when the input header is “License #”. Thanks.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema