Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following spreadhseet. I simply want to return the row with the last 'Sales' value. So in this case it should return
300, EAST
What would be the best way ?
Thanks
In the script or the front end?
in the script
Try this
Table:
LOAD RowNo() as RowNum,
SALES,
REGION
FROM
[..\..\Downloads\TESTV1.xlsx]
(ooxml, embedded labels, table is Sheet1)
Where Len(Trim(SALES)) > 0;
Right Join (Table)
LOAD Max(RowNum) as RowNum
Resident Table;