Importing Text File Problem

[zwyne]

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

[jyothish8807]

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,

KC

[jyothish8807]

There is a filed @14 also

[zwyne · Accepted solution]

Thank you.