Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
one of my qlikview dashboard I am loading daily csv file and id field is unique in that data. In few file ids are duplicate. but while loading from raw data (csv) file I am seeing that ID appears twice, but in the final QVD I am storing like Where not Exists([ID]), and after which only one id gets loaded. Just want to know is there way to check which id gets loaded first in qlikview?how to check which row gets loaded first?
May be use RowNo() in your script like
LOAD Field1,Field2, Field3, RowNo() AS RowNum
FROM YOURtablename;
If it's a SQL SELECT, you can use the ORDER BY to know what the driver will get first.
You can also do a first LOAD in QlikView using ORDER BY and then a LOAD on that table, and store the second table.