find two consecutive dates

AbbasZavar22

Hi there,

I have a data set of patients with their lab test results (+ the date of test).

Each patient may have several lab tests. I want to find the latest date of lab test (abnormal one) and the exact previous one (based on the date) for each patient.

Any recommendation on how I can get the latest date and the previous one (two consecutive dates)

MartinLiebig

Hi,

I would group into collection by patient id use loop collection, sort by time and use Filter Example Range to take the last 2.

BR,

Martin

BalazsBaranyRM

Hi!

This will work as long as the last lab test is the last entry by customer. If not, you could use Aggregate to get the date of the latest positive lab test, self-join with this entry, and use Generate Attributes (e. g. the date_diff() function) to determine if the entries are later. These can be filtered out with Filter Examples. 

Regards,
Balázs 

AbbasZavar22

mschmitz  

Could you please provide me with more explanation, step by step with the name of the operators? 
Thanks a lot in advance