How to Give A Status Old and New based on First Input Data
Hy Friends,
I have a little problem, I need to diplay the data based on input status (first time and after)
this is the data:
.png)
and this what I need to display
.png)
the notes become new because it is the first time that the data has been inputed, and it will become old if we have the data before (2nd data, 3rd data the notes will become old).
I've try to use SubQuery (with LAG Script also) but it doesn't works, because it will give a notes Old even it's a New Data
Does anyone could help me ?
Thank You
Best Regards,
Steven Henry
Product version: IRIS 2024.3
$ZV: IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2023.1.1 (Build 380_0_23762U) Fri Oct 18 2024 17:32:14 EDT [Health:5.1.0-1.m1]
Discussion (1)0
Comments
Hi, doesn't the answer from your previous similar (identical??) question solve your issue?
In particular I'm referring to the answer from Andreas Schneider using window functions.