Solved

[microwin88x]

Solved

[jagan · Accepted solution]

Hi,

Try like this

Temp:

LOAD

*,

Ceil(RecNo()/2) AS RecNo

INLINE [

ID, DATE, CODE

100, 01/05/2012 11:15, 1

100, 01/05/2012 11:35, 2

100, 12/08/2013 10:50, 1

100, 13/08/2013 10:23, 2

100, 15/10/2014 12:32, 1

100, 25/10/2014 16:18, 2];

Data:

LOAD

ID,

RecNo,

DATE AS 1

RESIDENT Temp

WHERE CODE = 1;

LEFT JOIN(Data)

LOAD

ID,

RecNo,

DATE AS 2

RESIDENT Temp

WHERE CODE = 2;

DROP TABLE Temp;

Regards,

Jagan.