How many record can be loaded from CSV file

[#1]

Dear all.

I am using the following code to load the data into qlikview from a csv file. I have 40k+ records in the CSV. But when i display the data in a table box. It only give me 19k+ records.

May i know is there any limitation on this or on the table box itself? How do i count the total number of record as well?

Directory;

LOAD D_PO,

     D_PARTNO,

     D_DESCRIPTION,

     D_UNIT_COST,

     D_ACCEPTED_QTY,

     D_ORDER_PLACED,

     D_YEAR,

     D_PERIOD,

     D_SUPPLIER,

     D_NAME,

     D_DEBITACCT,

     D_DEBITAMT,

     D_CREDITACCT,

     D_CREDITAMT

FROM

\\sgs-bit-01\QlikView\AccessPoint\DATA\donepo.csv

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

[Clever_Anjos]

Are you checking the Table Viewer? (Ctrl-T)

It´s the best way to check how many rows were loaded

[#3]

I went to to the table viewer but it doesnt show me the number of rows loaded. where can i check this? It only give me table view after i right click the table and click preview.

[Clever_Anjos]

Point you mouse to tablename and wait for 2 seconds, a pop-up will show up

[jagan]

Hi,

If you check Table box count it would differ with actual, because it removes duplicate rows.  You check Table Viewer? (Ctrl-T)

or In script try like this

LET vNoOfRows = NoOfRows('TableName');

and check the variable value in a Text Object.

Regards,

Jagan.

[#6]

I think Anjos and Mohan are correct.

The problem also in table box as it remove certain line. I checked the table viewer. It gives the all the rows.

But question now is why table box remove certain rows. I manage to found this. We have 4 unique row. But tablebox only display the top 3 rows and exclude the last one. May i know how come it didnt show the last row in table box as you can see all 4 rows are unique

[Clever_Anjos]

All those fields are into Table box?

QlikView Table Box show only distinct tuple of fields

[#8]

Yes. Those are the only fields.

Anyway, the first 3 row able to show in table box but not the last row.

Any different between the distinct and distinct tuple. I still cant figure out why the last row doesnt show

[Clever_Anjos]

Is it possible you post a sample with those 4 records?