topic Re: Applymap I guess? in QlikView

Applymap I guess?

Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

First off trust me I have searched the forum and can't seem to make this work.

I am reading from multiple sources. My source 1 is like a master that reads ID and Name,

Source 1

ID, Name

1, Peter

2, Michael

Source 2

ID,Name

1, Petr

2. Mikjael

For my second source I read ID again but Name is wrong here. So I would like to map like this: When ID then read Name from Source 1.

Edit: Without making a join, because I don't want all the fields from Source 1 to source 2 and vice versa I just want the information for ID/Name in the new table.

How can I make that?

Re: Applymap I guess?

sunny_talwar — Tue, 08 Nov 2016 11:59:37 GMT

Here is a good blog on how to cleanse your data: Data Cleansing‌

Re: Applymap I guess?

MindaugasBacius — Tue, 08 Nov 2016 12:03:14 GMT

The script would be following:

map:
Mapping Load *
From Source 1;

Table:
Load *
    ,ApplyMap('map', ID, Name) as NewName
From Source 2;