Discussion board where members can get started with QlikView.
I came to the following scenario where I Have to apply map 3 field named Area into one Table. The fields comes from 3 reports,].
Is it possible to merge all Mapping tables into one single field due to is named Area? to avoid having three field named area 1, area 2, area 4
Here is an example of what I need.
Area field contains areas: 1,2,3
Area field contains areas: 4,5,6
Area field contains areas: 7,8,9
Area field with all areas:1,2,3,4,5,6,7,8,9.
Thanks in advaced
Have you think about concatenate all Area values?
Trying That out.
Try to perform JOIN between the three tables and then perform the Lookup
Load * Resident Area123;
Load * Resident Area456;
Load * Resident Area789;
LOAD * INLINE [
The resulting table will contain all