Mapping Old Records to New Records - Part II

[Anonymous]

Hi,

I posted a question a few weeks ago in relation to mapping to sets of vendor transactions from two different ERP systems. I am attempting to link the old transactions to the new using mapping, which is linked to a spreadsheet.

Attached to this post you will find the script I am attempting to use, which doesn't fail to load all the data, but fails to link the data together. Is there something obvious I am missing?

Previous post was here..

MAPPING old records to new records.

[effinty2112]

Hi David,

In this part of your script shouldn't [Old_Vendor] read [Old Account Code]?

PurchaseData:

LOAD *, 

     ApplyMap('NavCodeMap',[Old Account Code]) AS [Account Code],

     ApplyMap('NavNameMap',[Old_Vendor]) AS Vendor

FROM

\\FILE\Users2\Qlik\MyFile2.qvd (qvd);  

All the best

Andrew

[Anonymous]

Hi Andrew,

This suggestion has joined the data together, always good to get another set of eyes looking at the script.

I can link the transactions, using the new account code, but i see two vendor names, old one and new one.

How do I get the NameMap to overwrite the old name, with the new one?

[beck_bakytbek]

Hi David,

you can use in this case the incremental load,

check this:Incremental Load in Qlikview - YouTube

i hope that helps

beck

[Anonymous]

Hi,

Not sure that this is what I am after - I want the data to load, but, when the vendor is brought across from the old system, if there is a matching record in the new system, the new value of vendor name should overwrite the old value. If there is no new value, use the old vendor name.