topic Finding an Issue while loading a text File in QlikView

Finding an Issue while loading a text File

padmanabhan_ram — Mon, 09 Feb 2015 15:34:36 GMT

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

Re: Finding an Issue while loading a text File

Anonymous — Mon, 09 Feb 2015 15:45:59 GMT

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

Re: Finding an Issue while loading a text File

rubenmarin — Mon, 09 Feb 2015 15:56:47 GMT

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.

Re: Finding an Issue while loading a text File

padmanabhan_ram — Tue, 10 Feb 2015 07:49:54 GMT

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

Re: Finding an Issue while loading a text File

Anonymous — Wed, 11 Feb 2015 19:41:09 GMT

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).

Re: Finding an Issue while loading a text File

Wed, 11 Feb 2015 19:45:15 GMT

Did you mess with Quoting options?