Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I've got a spreadsheet, that is records that are dated with a status and am looking for the most recent dated record to be in a display.
What is the best way to select that in the desktop version of the product?
I'm using the free download version of the product to evaluate it so, I've only done the free online training.
Any help is greatly appreciated.
load max(date)
resident yourtable
I want to have the other rows load so I can do trending on the data too. So I need some method for screening when I produce a chart. The latest date represents the most current status, the other rows (records) represent history for trending and point in time type analysis.
you can load as many times as you want. You can load the entire table and/or only the max date
tablemaxdate:
load max(date)
from yourtable;
Maintable:
load * from yourtable;