Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
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.
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.