Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this example
Add RowNo()
Load *,RowNo() From Table
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.
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
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
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
Check this example
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.