Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, please help with this task:
build table in Qlickview with worker ID by each day with Min and Max timestamp from row data it the examples below.
Can someone help with some ideas?
Try
A:
NoConcatenate
Load
Date(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Date,
Timestamp(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Time_stamp,
Worker
Resident Source
;
Drop Table Source;
Aggr:
NoConcatenate
Load
Date,
Worker,
Time(Min(Time_stamp)) as Min_Value,
Time(Max(Time_stamp)) as Max_Value
Resident A
Group By
Date,
Worker
;
Drop Table A;
Can you attach the sample spreadsheet?
Try
A:
NoConcatenate
Load
Date(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Date,
Timestamp(Timestamp#(Timestamp, 'MM/dd/yyyy hh:mm:ss TT')) as Time_stamp,
Worker
Resident Source
;
Drop Table Source;
Aggr:
NoConcatenate
Load
Date,
Worker,
Time(Min(Time_stamp)) as Min_Value,
Time(Max(Time_stamp)) as Max_Value
Resident A
Group By
Date,
Worker
;
Drop Table A;
If Vamsee's post got you what you needed, we would greatly appreciate it if you would close out your thread by using the Accept as Solution button on that post to mark it as the solution. This gives the poster credit for the help and lets the other Community Members know that it did work. If you are still working upon things, please leave an update post on what you still need.
Regards,
Brett