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.
