Splitting the input files into multiple files

[Anonymous]

Hi

I am new to talend and I have scenario where I have csv file with 250 columns with more records i need to split one input file into two o/p files based on the columns but all the columns are unique i.e I need to split first 150 columns into one output and rest in the other output file. can you please help or suggest me some option for this scenario

[TRF]

Use a tMap with 2 or more output flows with the desired columns selected from the input flow

[Anonymous]

Thanks. But I don't need manually selection of columns to output field.

Is there any way for automatically picking the first 150 columns from the input file and mapping into the output file??

[TRF]

In this case, a tJavaRow with String.split() should be the solution

[David_Beaty]

You probably want to use the tFileInputFullRow component as well to read in the entire line as one string.

Exercise care on what the input file is delimited on - dont use a delimiter that's possible to also appear within the data itself.

Thanks

David