topic Re: Mapping Old Records to New Records - Part II in QlikView

Mapping Old Records to New Records - Part II

Anonymous — Thu, 25 Aug 2016 11:26:42 GMT

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.

Re: Mapping Old Records to New Records - Part II

effinty2112 — Thu, 25 Aug 2016 13:04:07 GMT

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

Re: Mapping Old Records to New Records - Part II

Anonymous — Thu, 25 Aug 2016 14:02:36 GMT

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?

Re: Mapping Old Records to New Records - Part II

beck_bakytbek — Thu, 25 Aug 2016 14:10:07 GMT

Hi David,

you can use in this case the incremental load,

check this:Incremental Load in Qlikview - YouTube

i hope that helps

beck

Re: Mapping Old Records to New Records - Part II

Anonymous — Thu, 25 Aug 2016 14:24:33 GMT

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.