Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I need to find the second last record of this simple table. The condition is: if Version = 'Working Version' then last record of %Key1. I have solved this with extra column.
How do I get the 2nd last record for cases that %Key1 has a version "Working Version'? How can I flag the second last record in this scenario? I need the last Version = 'Latest'.
Hi @TomBond77 ,
Have a look at my script, I think this will do the trick :
Let me know if it works for you.
Regards,
Rohan.
Key2 is a reference field based on which the mapping is being done.
Regards,
Rohan.
Thanks @Rohan
Will this also work if there are more than one %Key1 record for DOC_REV value of "3" exist?
Yes.