Dissapeared rows in a plane table

[#1]

Hi

according to the table viewr I have a table with 96.162 rows.

In order to make some verifications I made a table box with all the fields but it has only 85.785 rows.

I think the reason is that there are some rows with all its fields equals so it shows them only once.

How could avoid this so I can take to excel 96.162 rows using the table box?

Thanks

[anbu1984]

Add RowNo()

Load *,RowNo() From Table

[rubenmarin]

Hi Luis,

In script, when you are creating the table, you can create a field like RowNo() as FileID, adding this field to the table box will make all records different.

[its_anandrjs]

Hi,

May be there is some fields are same and due to that it is display only 85785 for check add another field ROWNO() in the load script

Ex:-

Load

RowNo() As Rowid,

....

....

From Location;

Regards

Anand

[#5]

But I do not understand why I need to do so if the table is all right in memory with its 96.162 rows. Is the object 'Table Box...' which is not showing all the rows.

Does not exist a parametrer to say it 'show all'?

thanks

[ashfaq_haseeb]

May be few of your records are repeated.

That's the reason you need to add Rowno() Function.

'

Check this blog for better understanding.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/08/29/recno-or-rowno

Regards

ASHFAQ

[anbu1984 · Accepted solution]

Check this example

[Colin-Albert]

The table box only displays the unique values in the selected fields.

If there are any duplicate rows, then the data is only displayed once.

To view all rows, there must be a unique field on each row displayed in the table box.