Select last value in load script

[annabergendal]

How can I get unique SupplierID with last SupplierName from this record?

Also, I would only like to have last if it's not null, so I would like to have something like:

SupplerID, SupplierName, Datum

123, AA, 2014-03-01

121, B, 2014-01-01

122, CC, 2014-02-01

Thanks.

[jonasheisterkam · Accepted solution]

Hi,

try this.

load SupplerID, LastValue(SupplierName) Resident Table2 where len(SupplierName)> 0 Group by SupplerID ;

[annabergendal]

Thanks a lot,

works perfect