Discussion board where members can get started with Qlik Sense.
Could someone explain to me how to only load rows for a certain timestamp?
I have over 10k files with 900-100 rows because there is 24 rows pr. day and i am only interested in one of those rows.
This is my script for now.
"device-identification" as [Målernr.],
FROM [lib://Blåkildevej - 1108 - Water/*.csv]
(txt, codepage is 28591, embedded labels, delimiter is ';', msq)
The 'created' is my timestamp and looks like this:
Question -> What should I add to my load script, so that I only load the hour-timestamp 00:00 for every day, and exclude all the other hours....
you only need to add a "where" clausule like this:
where [created] like '*00:00:00';
With that your script will only load rows with the created column with a value that would end with 00:00:00.
I hope that helps you get what you want.
one solution would be to select the registers meeting your condition (hour =0) including the condition with the function "hour". Try using the following script:
(txt, codepage is 28591, embedded labels, delimiter is ';', msq) where hour (created)= 0;
I hope this helps,