Fetch second last record from date column.

[rupaliqlik]

Hi Team,

I have  a data set where I have one date column and other is patient id.User want to show second last date in report.

I used previous function but it is not working fine.Kindly help me.

Below is my code

[SR Infusion Temp]:
LOAD
[Patient ID] ,
[SR Infusion DOT],
Peek([SR Infusion DOT],-1) as _commondate
Resident [SR Infusion]
order by [Patient ID],[SR Infusion DOT] ASC;
DROP Table [SR Infusion];
RENAME Table [SR Infusion Temp] to [SR Infusion];

@abhijitnalekar ,sunny_talwar ,Kaushik Solanki

[a_mullick]

Hi,

See if this helps.

I've put in a set analysis solution and an alternative scripted solution, but basically you should be able to do what you want using the FirstSortevalue() function.