Return last value

[Anonymous]

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

[sunny_talwar]

In the script or the front end?

[Anonymous]

in the script

[sunny_talwar]

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;