topic Re: Problem while loading CSV file (1GB) records into Qlikview in QlikView

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

vikasmahajan — Mon, 02 Nov 2015 04:09:08 GMT

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

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

sunny_talwar — Mon, 02 Nov 2015 04:11:51 GMT

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

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

vikasmahajan — Mon, 02 Nov 2015 04:13:28 GMT

Thanks dear i will get back you.

Vikas

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

kashaboinaraj — Mon, 02 Nov 2015 08:43:37 GMT

TAMSAsset:

First 129106

LOAD

it will work surely

regards

vishnu