From what I can tell a Mapping Load works the same way as an Excel vLookup, where the ApplyMap used in the table will always find the first available match and then disregard any other matches.
I need it to use the very last match in the mapping table. How can I achieve that?
I think I need to sort the mapping table - I can do this using a field called [Decision Date] or I can use RowNo() and sort it descending - but I;m not sure how to do this - can someone please assist? Is there an opposite to First Sorted Value?
My current script looks something like this:
MapOrigin:
Mapping Load
[Appl No],[Appl Origin Code]
From C:\Users\tenba1\Documents\QlikView\AppsQVD.qvd (qvd); // this I need to sort from bottom to top using date or row
Table:
ApplyMap('MapOrigin', [Appl no], 'Branch App') As [Appl Origin Code]
