txt file reading and count mismatch

[Anonymous]

Hello experts,

I am trying to load text file data into qlikview document. after loaded I could see counts mismatch between actual source count and table chart count in qlikview.

I have loaded complete data into qlik documnet and created one table box by pulling all columns into chart. Aftre that I could see count mismatch between source vs chart.

Any help on this.

Regards,

Kumar

[jwjackso]

When I have had a similar problem, I added "RecNo() as RecID" as a field in the load so that I could verify that every record loaded matched the source file.

[Anonymous]

Thanks Jerry for your quick reply.

But in my source I have 20K records available. It is difficult to match one by one.

I have already tried with that RecNo().

My concern is why it is not fetching all 20k records.

Even at the time of loading also it is having less count.

Regards,

Kumar

[jwjackso]

I had similar problems.  In qlikview I had a tablebox with all the fields from the questionable table. I exported that to Excel.  I loaded the source file into Excel and that is where I did the comparison.

When you loaded the file and used the RecNo() function, did the maximum value for the RecNo() field equal the records in your source file?

Do you have any fields that have special characters?

[settu_periasamy]

Do you have duplicate records in your text file? Table box shows only unique records .

And, Can you check the count in the Table Viewer?

[Anonymous · Accepted solution]

I have modified this option as highlighted in below screen shot. It worked.