Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madmax88
Contributor

Edit previous loaded data

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...

1 Solution

Accepted Solutions

Re: Edit previous loaded data

Perhaps this?

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies

Re: Edit previous loaded data

Perhaps this?

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
madmax88
Contributor

Re: Edit previous loaded data

It Works, thanks!