Discussion Board for collaboration on QlikView Scripting.
I have a table contains two columns
in Script i want to add to this data table a column from another table: Department
The result should be:
Department Size Length
A 1 2
B 1 2
how can I do that?
Thanks in advance
Load Size, Length,1 as Dummy;
Load * inline [
1 , 2 ];
Load Department,1 as Dummy;
Load * Inline [
You can perform a join (INNER, LEFT, RIGHT).
The join is a Natural Join made over all the common Fields (where the field name is the same).
If your two tables do not share a common field as you above example you can use the JOIN prefix to get your desired result. See below
LOAD * INLINE
1 , 2
Use applymap () by using if any matching column :
ApplyMap(' ProductMap ' ProductName ) as ProductID,