topic Re: Loading order in qlikview in QlikView

Loading order in qlikview

Anonymous — Mon, 18 Jun 2018 14:26:20 GMT

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?

Re: Loading order in qlikview

vishsaggi — Mon, 18 Jun 2018 14:38:26 GMT

May be use RowNo() in your script like

LOAD Field1,Field2, Field3, RowNo() AS RowNum

FROM YOURtablename;

Re: Loading order in qlikview

Miguel_Angel_Baeyens — Mon, 18 Jun 2018 14:41:32 GMT

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.