DSXchange

Hi, I have a file which has header in 1st row and tailer in last row. ex: " This is a test desciption 1,120,hyd 2,250,che 3,350,Bang total is 720 " in the above file 1st line is header, last line is tailer. in between is the data. Now i want to read only data(ie header, tailer and data sep...

Hi,

Can anyone pls explain me the difference between normal look up and sparse lookup.
If i want to use sparse lookup, how do i set the options in the stage for sparse lookup.

Thanks in advance to one and all for the gr8 help.
Mallika

Hi Chulett,

The file is like

111, "Mallika", India
121 "Chaithu" US
123, "Krishna", China

in the above file i have comma separated data in row-1 and space separated data in row-2.
So this file i want to read.

Hi,

I have text file which has multiple seperators in the data. (i.e the data consists of comma separator, space seprator in the same file)
I want to read this file using sequential file stage.
Can you guys help me how can i proceed.

Thanks