You need to follow some thing like this
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
Tab:
LOAD * INLINE [
Name, Location, Pickup
1, A, AA
2, D, DD
3, F, WW
4, A, EE
5, A, EE
6, D, RR
7, F, RR
8, T, TR
9, W, QA
];
Data: NoConcatenate
LOAD
RecNo() as Number
,*
Resident Tab;
DROP table Tab;
MainData:NoConcatenate
LOAD * INLINE [
Name, Location, Pickup,2
Name, Location, Pickup,2
];
Concatenate(MainData)
LOAD
*
Resident Data where Number<=3;
Concatenate (MainData)
LOAD * INLINE [
Name, Location, Pickup,3
Name, Location, Pickup,3
];
Concatenate (MainData)
LOAD *
,RecNo() as Phase1
Resident Data where Number>3 and Number<=6;
Concatenate (MainData)
LOAD * INLINE [
Name, Location, Pickup,4
Name, Location, Pickup,4
];
Concatenate (MainData)
LOAD *
,RecNo() as Phase3
Resident Data where Number>6 and Number<=9;
Drop Table Data;
AllData:
Load
Name, Location, Pickup,Number
Resident MainData ;
DROP Table MainData;
