Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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.
Source:
Report 1:
Area field contains areas: 1,2,3
Report 2:
Area field contains areas: 4,5,6
Report 3:
Area field contains areas: 7,8,9
Target:
Final report:
Area field with all areas:1,2,3,4,5,6,7,8,9.
Thanks in advaced
Hi,
Have you think about concatenate all Area values?
Saludos.
Trying That out.
Thanks
Try to perform JOIN between the three tables and then perform the Lookup
Thanks
CY
Load * Resident Area123;
(Concatenate)
Load * Resident Area456;
(Concatenate)
Load * Resident Area789;
or
Area123:
LOAD * INLINE [
Area
1
2
3
];
Area456:
LOAD * INLINE [
Area
4
5
6];
Area789:
LOAD * INLINE [
Area
7
8
9
];
The resulting table will contain all