Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zwyne
Creator
Creator

Importing Text File Problem

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

1 Solution

Accepted Solutions
zwyne
Creator
Creator
Author

3 Replies
jyothish8807
Master II
Master II

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

Best Regards,
KC
jyothish8807
Master II
Master II

There is a filed @14 also

Best Regards,
KC
zwyne
Creator
Creator
Author