topic Re: Reading delimited file with dynamic columns in Talend Studio

Reading delimited file with dynamic columns

Karuetl — Tue, 27 Nov 2018 21:44:45 GMT

I will have multiple files which has different columns in the each file but i want to read each file and filter out any rows matching in the file and load into new delimited file

how can i achieve this

I tried using tfilerawinput as object which works fine in reading the file but filtering the data is not working fine

Re: Reading delimited file with dynamic columns

Anonymous — Wed, 28 Nov 2018 03:04:16 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Reading delimited file with dynamic columns

Karuetl — Wed, 28 Nov 2018 03:41:21 GMT

We have multiple files based on different tables

File 1 will have 5 columns

File 2 will have 3 columns

FIle 3 will have 6 columns

In each of these files there will be acct number

So I have to read each file and search for the acct number and if found discard that from the file and load into new output file

Re: Reading delimited file with dynamic columns

Anonymous — Wed, 28 Nov 2018 10:08:41 GMT

Hello,

If I understand your job requirement very well, tMap is the component what you are looking for.

You can set filters for your input files in tMap and then load required columns into a new output file.

Please refer to tMap component reference with examples.

TalendHelpCenter:tMap scenarios

Best regards

Sabrina