Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Pipe Delimited file with variable columns like shown below.
Row1 --column1|column2|column3|
Row2 --Column1|column2|column3|column4|column5|
Row3--colum1|column2|column3|column4|
Tried with different ways to read this file, able to read the file, but not able to do any further filter.
My requirement is based on column3 value, a different file to be created.
Any thoughts how to achieve this in Talend.
Thanks,
Uday
@udaya paduchuri , you can use tfilterrows component and you can filter and generate the required output file.
Thanks,
Manohar
@Mano--I tried that way, but the problem is the columns are not consistent, hence tfilter is not working.
Hi Uday,
If you have the headers for all the 5 columns, then after reading the file you can use a tMap to split according to column 3 and output the result to separate files.
@Ani--Unfortunately, there are no headers for the columns.
Thanks,
Uday