Load data: Min and max value by day in Data Load Editor

mvtriff — Tue, 01 Jun 2021 19:11:47 GMT

Hi everyone,

Could you please help me with the script below?

I need to import the measurements from the last 30 days (this is already done and it works) and for each datetime the min value and max value corresponding to that datetime.

What should I add to the script below?

Many thanks.

[measurements]:
LOAD
[id] AS [measurements.id],
[deviceid],
[datetime] AS [measurements.datetime],
Date(floor([datetime]) , 'DD/MM/YYYY') as [measurements.date],
[value],
[measurementlistid];
SELECT id,
deviceid,
datetime,
`value`,
measurementlistid
FROM ebdb.measurements
WHERE datetime >= '$(v30DaysAgo)'

Re: Load data: Min and max value by day in Data Load Editor

rwunderlich — Tue, 01 Jun 2021 19:43:41 GMT

MinMax:
LOAD
[measurements.datetime]
Min(value) as MinValue,
Max(value) as MaxValue
Resident measurements
Group by [measurements.datetime]
;

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

topic Re: Load data: Min and max value by day in Data Load Editor in Connectivity & Data Prep

Load data: Min and max value by day in Data Load Editor

Re: Load data: Min and max value by day in Data Load Editor