Join Tables in only one

[#1]

I have 2 tables.

Table 1:

Table 2:

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

Anyone help me?

[Gysbert_Wassenaar · Accepted solution]

MapCodDesc:

mapping load

Cod, Description

from ...table2source...;

Result:

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

from ...table1source...;

[#3]

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]

Use applymap ()

This video may help

https://www.youtube.com/watch?v=jby-omVFNzI&feature=youtube_gdata_player