Edit previous loaded data

[madmax88]

Hi,

Is it possible to edit previous loaded data in the data Editor?e.g.

Sales:
Load
Advisor,
Product,
Month_Year,
Value
From...

Match Table:
Advisor,
Region
From...

Goal Table:
Region,
Goal,
Month_Year
From...

this is actually not possible because "Region" und "Advisor" are 2 different keys.
Is it therefor possible in the "sales table" to replace "Advisor" with "Region"

At the end I must have Table Sales without Advisor but with the correct Region.

Target:

Sales:
Load
Region,
Product,
Month_Year,
Value
From...

Match Table:
Advisor,
Region
From...

Goal Table:
Region,
Goal,
Month_Year
From...

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

[Match Table]:
Mapping Load Advisor, Region From ..;

Sales:
Load ApplyMap('Match Table', Region) as Region,
Advisor, Product, Month_Year, Value
From...

[madmax88]

It Works, thanks!