topic Mapping Load advise in QlikView

Mapping Load advise

jgarciaf106 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Mapping Load advise

fvelascog72 — Tue, 17 Apr 2018 15:09:48 GMT

Hi,

Have you think about concatenate all Area values?

Saludos.

Re: Mapping Load advise

jgarciaf106 — Tue, 17 Apr 2018 15:12:13 GMT

Trying That out.

Thanks

Re: Mapping Load advise

ychaitanya — Tue, 17 Apr 2018 16:00:09 GMT

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

Thanks

Re: Mapping Load advise

Anonymous — Wed, 18 Apr 2018 00:28:38 GMT

Load * Resident Area123;

(Concatenate)

Load * Resident Area456;

(Concatenate)

Load * Resident Area789;

Area123:

LOAD * INLINE [

Area

];

Area456:

LOAD * INLINE [

Area

6];

Area789:

LOAD * INLINE [

Area

];

The resulting table will contain all