topic Re: Update the column value from a previous row in Data Movement & Streaming

Update the column value from a previous row

Paulo_IntelFab — Wed, 19 Mar 2025 21:48:59 GMT

Hi, guys.
I need to set the downtime value of a machine according to the time where the machine stop occurred.
My table is something like this:

Shift	Interval	Interval	Downtime
1	12	07:34:34	0
2	1234	14:12:12	398

In this case, I need to split the downtime between Shifts 1 and 2 (because most of time stopped was on Shift 1).
The expected values are something like this:

Shift	Interval	Interval	Downtime
1	12	07:34:34	386
2	1234	14:12:12	12

How can I, detecting this change of Shift (using Previous(Shift), update the last row of the Shift 1?
I appreciate any help.

Re: Update the column value from a previous row

pedrobergo — Tue, 20 Aug 2024 19:57:15 GMT

Hey @Paulo_IntelFab

Which product you´re referring to?

This forum is for Qlik Cloud Data Integration.

[],

Pedro

Re: Update the column value from a previous row

Paulo_IntelFab — Tue, 20 Aug 2024 20:25:02 GMT

Hi @pedrobergo . Thanks for replying.
I'll try on another forum.