topic Re: data load problem in QlikView

data load problem

Wed, 04 Jun 2014 07:29:03 GMT

Hi All,

I'm trying to load a csv file which is having 95,000+ rows. Loading is successful but all the rows are not getting loaded. So could you please suggest some option to load entire data.

Thnaks!!!

Re: data load problem

hic — Wed, 04 Jun 2014 07:30:33 GMT

Why do you think that all data isn't loaded? What's the symptom of the problem?

HIC

Re: data load problem

its_anandrjs — Wed, 04 Jun 2014 07:34:30 GMT

You can cross check that your file is loaded completely or not by using

TableName:

Load * From CsvLocation;

Let vNoFields = NoOfFields('TableName');

Re: data load problem

Wed, 04 Jun 2014 07:34:53 GMT

I'm not able to see few rows in edit script preview. And I'm not able to see few records in list box.

Re: data load problem

Wed, 04 Jun 2014 07:39:48 GMT

vNorows shows 33

Re: data load problem

its_anandrjs — Wed, 04 Jun 2014 07:40:23 GMT

Did you check you can use proper Delimiter Like Semicolon, Comma, Tab, Spaces

Re: data load problem

its_anandrjs — Wed, 04 Jun 2014 07:42:04 GMT

Check with your csv file there is 33 fields are same or not

Let vNoOfFields = NoOfFields('TableName');

and also Did you check you can use proper Delimiter Like Semicolon, Comma, Tab, Spaces

Re: data load problem

hic — Wed, 04 Jun 2014 07:46:25 GMT

How many rows do you see?

If you mark a list box, you will get some numbers to the right of the status bar (bottom right).

These show some interesting things:

The "D: 4/52" means that my selection has 4 distinct values possible of 52 in the field.

The "F: 146/772" means that there are 146 records possible of 772 loaded (in the table where the field in question exists).

So, which numbers do you have there?

HIC