Extract data from data by conditionally

[nihhalmca]

Hi All,

Please have a look at attachment for details.

Thanks,

Nihhal.

[ahaahaaha]

Hi Nihhal,

May be as at attached file.

Regards,

Andrey

[vinieme12]

do you already have a flag that specifies start and end date?then just use

Max({<Dateflag={'StartDate'}) Date) for StartDate

and Max({<Dateflag={'EndDate'}) Date) for EndDate

[nihhalmca]

Hi Andrey,

Thanks for your attachment.

Actually i have to give logic while extracting data from table (edit script) instead of UI.

I need to extract only required records from data source (latest startdate and enddate per each patid) instead of all records.

[maxgro · Accepted solution]

S:

LOAD PatID,     Code,      Date

FROM [Source.xlsx] (ooxml, embedded labels, table is DB);

S1:

NoConcatenate

load PatID, Code, Date as EndDate

Resident S

Where PatID <> Peek('PatID')

order by PatID, Code desc;

left join (S1)

load PatID, Code +3 as Code, Date as StartDate

Resident S;

DROP Table S;