Problem while loading CSV file (1GB) records into Qlikview

[vikasmahajan]

Dear Team,

I have big size csv file (1GB)  when I am trying to load into Qlikview  it is not picking up all records it stuck on record no 129107 i have 1009854 total records.

Script :

TAMSAsset:

LOAD

     *

FROM

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

//(txt, utf8, embedded labels, delimiter is ',', msq);

Please any one can guide what could be the issue ?

Vikas

Thanks in adv

[sunny_talwar · Accepted solution]

Not sure what could be the issue, but try and load this:

TAMSAsset:

First 129106

LOAD

     *

FROM

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

The above should go through without any issue (If it does not, you need to look into other possibilities)

Next try this and see if it still get stuck:

TAMSAsset:

First 129108

LOAD

     *

FROM

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

[vikasmahajan]

Thanks dear i will get back you.

Vikas

[kashaboinaraj]

TAMSAsset:

First 129106

LOAD

     *

it will work surely

regards

vishnu