
Partner - Creator
2015-01-18
03:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Select last value in load script
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.
1,633 Views
1 Solution
Accepted Solutions


Partner - Creator III
2015-01-18
04:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try this.
load SupplerID, LastValue(SupplierName) Resident Table2 where len(SupplierName)> 0 Group by SupplerID ;
1,032 Views
2 Replies


Partner - Creator III
2015-01-18
04:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try this.
load SupplerID, LastValue(SupplierName) Resident Table2 where len(SupplierName)> 0 Group by SupplerID ;
1,033 Views

Partner - Creator
2015-01-18
04:29 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot,
works perfect
1,032 Views
