Dynamic pass through fields from csv file

Highlighted
Seven Stars

Dynamic pass through fields from csv file

So I have csv file & for the most part, it has fixed schema except it has few additional columns at end that I just need to pass through in output data

 

csv file schema:-

  1. fname
  2. lname
  3. address1
  4. address2
  5. city
  6. state
  7. zip
  8. dynamicfield1
  9. dynamicfield2
  10. dynamicfield3

here I have dynamic fields from 8 to 10, and field names also varies for those dynamic fields.

 

I dont need to do any processing on these dynamic fields, I just need to pass this through in the output data.

 

what is the best approach to achieve this scenario?

 

we have using enterprise version talend data integration v 6.4. any help on this would be really appreciated. 

Forteen Stars

Re: Dynamic pass through fields from csv file

@nmodi ,you can do with one dynamic data type column for the 8 to 10 column with enterprise edition.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch 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