Reading delimited file with dynamic columns

[Karuetl]

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 

[Anonymous]

Hello,

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

Best regards

Sabrina

[Karuetl]

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 

[Anonymous]

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