Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

davidmcfall
Not applicable

Mapping Old Records to New Records - Part II

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.

4 Replies
effinty2112
Not applicable

Re: Mapping Old Records to New Records - Part II

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

davidmcfall
Not applicable

Re: Mapping Old Records to New Records - Part II

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
Not applicable

Re: Mapping Old Records to New Records - Part II

Hi David,

you can use in this case the incremental load,

check this:Incremental Load in Qlikview - YouTube

i hope that helps

beck

davidmcfall
Not applicable

Re: Mapping Old Records to New Records - Part II

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.