Last 25 records with data

ishanahiya — Wed, 22 Jan 2020 03:08:44 GMT

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?

Re: Last 25 records with data

jonathandienst — Wed, 22 Jan 2020 04:44:34 GMT

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;

topic Re: Last 25 records with data in App Development

Last 25 records with data

Re: Last 25 records with data