Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Join Tables in only one

I have 2 tables.

Table 1:

table1.PNG

Table 2:

table2.PNG

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

new table.PNG

Anyone help me?

1 Solution

Accepted Solutions

Re: Join Tables in only one

MapCodDesc:

mapping load

Cod, Description

from ...table2source...;

Result:

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

from ...table1source...;


talk is cheap, supply exceeds demand
3 Replies

Re: Join Tables in only one

MapCodDesc:

mapping load

Cod, Description

from ...table2source...;

Result:

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

from ...table1source...;


talk is cheap, supply exceeds demand
Not applicable

Re: Join Tables in only one

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
Honored Contributor II

Re: Join Tables in only one

Community Browser