topic Select last value in load script in QlikView

Select last value in load script

annabergendal — Sun, 18 Jan 2015 20:52:07 GMT

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 — Sun, 18 Jan 2015 21:20:00 GMT

Hi,

try this.

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

annabergendal — Sun, 18 Jan 2015 21:29:59 GMT

Thanks a lot,

works perfect