Discussion Board for collaboration on QlikView Extensions.
I'm also new and have following questions to my Problem:
I have a database or excel doc, which need to be updated, because some lines are wrong.
Table2 (excel): // with updated lines/values
I want to update Table1 by integrate with Table2.
With the funktion Inline, I can only add the "Age"-value. But in this case, I want to replace:
How could this be solved with Qlikview? Via script or funktion/ formel ?
Go to Solution.
use apply map instead as shown below.
Mapping load * Inline
load *, ApplyMap('Map',ID,Age) as New_age;
load * inline
View solution in original post
Try like this
load * Inline
If(IsNull(NewAge), Age, NewAge) AS Age
DROP TABLE Temp;
What about if I have more fields then 5 im my source, and I want just Replace 1 of them, if it needs:
ID, Age, Mood, Color
Here I only want to update the 2x'Mood' and 1 'Color' of 2 IDs.
My solve-thinking would be: that I have to separate in 4 tables to join or mapping them?
Am I thinking right?
Use Apply map instead of join.
Yes, use 4 different applymaps.