Last 25 records with data

[ishanahiya]

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?

[jonathandienst · Accepted solution]

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;