Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jgarciaf106
Creator
Creator

Mapping Load advise

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

4 Replies
fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

Have you think about concatenate all Area values?

Saludos.

jgarciaf106
Creator
Creator
Author

Trying That out.

Thanks

ychaitanya
Creator III
Creator III

Try to perform JOIN between the three tables and then perform the Lookup

Thanks

CY

Anonymous
Not applicable

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