Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
jgarciaf106
New Contributor III

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
Highlighted
Partner
Partner

Re: Mapping Load advise

Hi,

Have you think about concatenate all Area values?

Saludos.

Highlighted
jgarciaf106
New Contributor III

Re: Mapping Load advise

Trying That out.

Thanks

Highlighted
ychaitanya
Contributor III

Re: Mapping Load advise

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

Thanks

CY

Highlighted
delroekid
Contributor

Re: Mapping Load advise

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