Applymap I guess?

[#1]

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?

[sunny_talwar]

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

[MindaugasBacius]

The script would be following:

map:
Mapping Load *
From Source 1;

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