Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can load the first 25 records from the ModifiedDate field with this script
First 25
Load
ModifiedDate
from DateWorksheet.csv;
However instead, I want to load the last 25 records with data from the ModifiedDate field so empty records are excluded. Can you help?
If you are loading from a CSV, you probably cant avoid loading all the date first to do this. Something like this:
T_Data:
LOAD *, RowNo() as RowID
FROM <your data source>
WHERE Len(ModifiedDate) > 0;
Let zRowCount = Peek('RowID');
Data:
NoConcatenate
LOAD *
Resident
WHERE RowID >= $(zRowCount) - 25;
DROP Table T_Data;
If you are loading from a CSV, you probably cant avoid loading all the date first to do this. Something like this:
T_Data:
LOAD *, RowNo() as RowID
FROM <your data source>
WHERE Len(ModifiedDate) > 0;
Let zRowCount = Peek('RowID');
Data:
NoConcatenate
LOAD *
Resident
WHERE RowID >= $(zRowCount) - 25;
DROP Table T_Data;