topic Re: Importing Text File Problem in QlikView

Importing Text File Problem

zwyne — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expert,

PFA

I have a delimiter text file (delimiter = ~) which I am importing to Qlikview. The problem is that it does not import all of the data and when I view it on Notepad++ I should have 13 colums instead of 11.

Please assist.

Thanks

Re: Importing Text File Problem

jyothish8807 — Fri, 16 Mar 2018 12:27:29 GMT

Hi,

I manually added @12 and @13 and i am able to fetch the data.

LOAD @1,

@2,

@3,

@4,

@5,

@6,

@7,

@8,

@9,

@10,

@11,

@12,

@13

FROM

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

Br,

Re: Importing Text File Problem

jyothish8807 — Fri, 16 Mar 2018 12:28:25 GMT

There is a filed @14 also

Re: Importing Text File Problem

zwyne — Fri, 16 Mar 2018 13:16:45 GMT

Thank you.