how to extract few columns from many number of columns ?

[prabuj]

Dear Team, @Shicong Hong @Xiaodi Shi @Fred Trebuchet,

I have 232 columns in a single csv file and I have 3 types of data in it.

I want to extract data from

56,57,58,59,60th column (insurer data) ,

65,66,67,68,69th column (owner data)

98,99,100th column (assignee ) and merge all these data in a row way.

1. I tried using tfiltercolumns, to separate the columns which is insurer, owner, assignee.
2. In that insurer, owner data comes perfectly, but the data in assignee is wrong.
3. It's collecting data from the previous column ( like 95th column ).
4. I tried using tMap to correct it , but still wrong!

When I try to collect the data only for 98,99,100.. it's all empty.. but source have data.!

**I gave a try to just load the data from the input to output. THE DATA IS PERFECT.. !

How is it possible ? IT's just throw empty only " when I try to extract separately 98,99,100th columns'

 

What would be the problem (or) tell me a best design. ?

Thanks in advance.

[Anonymous]

Try to create the file metadata and preview the data with table format, to check and confirm 98,99,100th columns (assignee ) have data.

BTW, does the file has header line?

[prabuj]

@Shicong Hong​ the source contain the data, when i try to extract the data for those 3 columns it's empty.

 

Thanks in advance.