Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to increment with a millisecond for each change of RecordNumber and NRVD, but just when the data is maximum. Like in the sample attached.
Thank you,
Hi,
I succeed to implement. It only needed to use peek(Flag,-1) insead of using peak(Date,-1).
Thank you anyway for your suggestions.
Best regards,
Cosmina
Hi,
not quite right, but maybe helpful:
LOAD *,
Timestamp(Date+(AutoNumber(RecNo(),RecordNumber&'|'&Date)-1)*'00:00:00.001','DD.MM.YYYY hh:mm:ss.fff') as Result;
LOAD RecordNumber,
NRVD,
Timestamp#(Date,'DD.MM.YYYY hh:mm:ss') as Date
FROM [https://community.qlik.com/servlet/JiveServlet/download/1155190-252649/Sample.xlsx] (ooxml, embedded labels, table is Sheet1);
Can you elaborate what you meant with "...when the data is maximum." ?
thanks
regards
Marco
Hi Marco,
Thank you for the reply. I loaded the data and haven't got the expected results.
With maximum i meant. Ex. For RecordNumber 1 and NRVD 33, the maximum date is 12.10.2016 so no incrementation needed, because the date for the other RecordNumber 1 and NRVD 33 is less than 12.10.2016.
For RecordNumber 1 and NRVD 2, the maximum date is 10.10.2016 00:10:10, so yes is needed the incrementation for all records with RecordNumber 1 and NRVD 2 and 10.10.2016 00:10:10, as you allready implemented correctly.
For RecordNumber 1 and NRVD 2, the maximum date ist 10.10.2016 00:10:10, so for all RecordNumber 1 and NRVD 2 and date 10.10.2016 00:10:10 i have to apply the incrementation. But not for the duplicated rows with RecordNumber 1 and NRVD 2 and date 09.10.2016 00:10:20, because 09.10.2016 is less than the maximum date, 10.10.2016. Here i misspelled in the sample 10.10.2016 00:10:20 istead of 09.10.2016 00:10:20.
Also, for RecordNumber 2 and NRVD 33, has to start with milisecond 000, then incrementing.
Best regards,
Cosmina
Hi,
I succeed to implement. It only needed to use peek(Flag,-1) insead of using peak(Date,-1).
Thank you anyway for your suggestions.
Best regards,
Cosmina