Finding an Issue while loading a text File

[padmanabhan_ram]

HI,

I am trying to load the attached text file in QlikView with delimiter as comma, after loading the text file in QlikView I do not get the desired output, the values are getting misplaced.

I guess it's a qualifier issue.

How can I specify the qualifier in QlikView while loading the text file.

Thanks and regards,

Padmanabhan

[Anonymous]

I see the problem with the text file layout.  The attached version works.

[rubenmarin]

Hi Padmanabhan, to specify the delimiter you can use:

LOAD ...

FROM

[.\test.txt]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

As Michael saids, there was a problem in txt, it has 2 rows instead of 1.

[padmanabhan_ram]

Thanks for the response Michael.

But we receive the source file in the format of 'test.txt' where a record continues in the second and third line. It's like each record will occupy multiple lines in the text file.

So are there any solution in QlikView to get the desired output.

Thanks,

Padmanabhan

[Anonymous]

It depends...  Maybe you'll be better of with some 3rd party tools that I don't know of, but QV has a lot of functionality which may help.  See the attached example (I used your text file, and added another record in two lines, same structure).

[#6]

Did you mess with Quoting options?