*** How to get second date for each trade id ****

[#1]

hi all,

PFA excel sample data.

from this data i need to form 2 fields

Field1 --> 2nd date from DAte1 column by each trade id

Field 2 --> 2nd date from last in Date2 Column by each trade id

I tried many way but facing prob.

Please suggest me some way to get it done ASAP.

Thanks

[Nicole-Smith]

See the attached for full example:

Data:

LOAD tradeid,

     date1,

     date2

FROM

[data sample.xlsx]

(ooxml, embedded labels, table is Sheet1);

left join (Data)

LOAD tradeid,

     date(FirstSortedValue(date1, date1, 2)) as Field1,

     date(FirstSortedValue(date2, -date2, 2)) as Field2

RESIDENT Data

Group by tradeid;