Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table1:
Date
Table2:
Test:
LOAD Date&'-'&Amt as Key,
Date,
Amt,
Id,
RowNo() as RowNo
FROM
Table1.xls
(biff, embedded labels, table is Sheet1$);
Table2.xls
Test1:
LOAD RN;
LOAD Key as Key1,
Min(RowNo) as RN
Resident Test
Group By Key;
Left Join (Test1)
LOAD Key,
RowNo as RN
Resident Test;
Drop Table Test;