topic Re: Join Tables in only one in QlikView

Join Tables in only one

Tue, 16 Jul 2013 18:44:39 GMT

I have 2 tables.

Table 1:

Table 2:

And I need create a qlikview's table like this:

Anyone help me?

Gysbert_Wassenaar — Tue, 16 Jul 2013 18:50:01 GMT

MapCodDesc:

mapping load

Cod, Description

from ...table2source...;

Result:

load Level, Code, Value, applymap('MapCodDesc',Cod) as Description

from ...table1source...;

Tue, 16 Jul 2013 19:20:10 GMT

Probably, you are looking for this kind of syntax:

LOAD * FROM souce1;

join

LOAD * FROM source2;

it's working but, If I'm correct, The mapping load is more optimized.

Gysbert, could you confirm that?

rustyfishbones — Tue, 16 Jul 2013 19:29:57 GMT

Use applymap ()

This video may help