topic Re: Timestamp order during load from qvd in Connectivity & Data Prep

Timestamp order during load from qvd

arnould_it — Thu, 09 Nov 2017 09:36:09 GMT

Hello to all,

Could anyone suggest me how to correctly order records using Timestamp, loading from a qvd? I've tried in many ways but without success until now.

I've to compare any record with its previous, but to do this the records have to be in ascending order during comparison.

I've also tried ordering records after having loaded them from qvd, using a resident table, but it doesn't work anyway.

This is my timestamp format: 'DD.MM.YYYY hh:mm:ss[.fff]'.

I'm using Qlik Sense.

Thank you in advance for your suggestions

Alessandro

shraddha_g — Thu, 09 Nov 2017 09:42:50 GMT

What is the format of data in qvd?

Can you share sample data?

arnould_it — Thu, 09 Nov 2017 10:15:20 GMT

This is the original format from a csv file: "04.11.2017 07:00:01"

This is the script set: SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

arnould_it — Thu, 09 Nov 2017 10:23:20 GMT

This is a screenshot from the qvd:

it seems ok but when I load it the order sometime changes

m_s — Thu, 09 Nov 2017 12:17:16 GMT

Are you loading your QVD like

LOAD
    *
FROM qvd-file.qvd(qvd)
ORDER BY Timestamp;

and if yes does it still not work?

If so maybe try adding a field containing the numeric timestamp (Num(Timestamp)) and order by that.

Mathias

arnould_it — Thu, 09 Nov 2017 13:16:56 GMT

Thanks Mathias,

using (num(timestamp)) it does work.