topic Re: Order of result from load in App Development

Order of result from load

matspersson — Sat, 14 Sep 2019 13:43:46 GMT

Loading from a qdf or resident table, is there any guaranties for in which order the rows are returned. E.g. the order they where inserted in the first place into the qdf or resident table.

Cheers

Mats

Re: Order of result from load

matspersson — Sat, 14 Sep 2019 15:32:17 GMT

Sorry, meant qvd file.

Re: Order of result from load

Vegar — Sat, 14 Sep 2019 15:49:45 GMT

It is a good question. I have not seen anything in the qlik documentation about load order from QVC, as long its undocumented there is no guarantee in behaviour. However you could assume the data to be loaded as entered into the qvw.

If your order of data is important then you should order it explicit.

OrderedTable:

NoConcatenate

Load

Resident

UnorderedTable

Order by

YourOrderField

;

Drop UnorderedTable;

Re: Order of result from load

marcus_sommer — Mon, 16 Sep 2019 12:30:31 GMT

AFAIK the order depends of the point of view - from the data-table or from the symbol-table. The data-table is always loaded with the order from the source - unless you apply an order by statement. From the point of view of the symbol-table respectively the (distinct) fieldvalues it's different because it depends on whether the field exists already.

If the field didn't exists the load-order is identically with the load-order of the data-table but if the field exists only new fieldvalues are added and the pointer increased to one bit and is stored in the data-table - otherwise it's just a lookup to fetch the right pointer value.

You may check this with some of your data and/or a few dummy-data by applying recno/rowno to your origin and deduced loadings and maybe even to your source-data (which may stored in a different order as they are displayed).

- Marcus