From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

dynamic schema question

Highlighted
One Star

dynamic schema question

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.

Highlighted
Moderator

Re: dynamic schema question

Hi,
Could you please indicate what's the build version you are using?
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.
Highlighted
One Star

Re: dynamic schema question

Currently we are using version 5.5.1, but will be going to version 5.6.2 soon.
Highlighted
Moderator

Re: dynamic schema question

Hi,
Does this issue also repro on V 5.6.2? We will make a testing on V 5.5.1 to see if this issue repro on our side.
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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog