Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Look up values from similar results of different dimensions

I have 2 different tables with different dimension but the values in these dimensions are almost same. Is there a way I I would like to lookup values from Dimension 1 to Dimension 2 in a different table.

Eg. Table 1 has gender and their respective population.

     Table 2 has Gender(Different Data Field Name) and their consumption. I want to include the population as well in table 2.

P.S. I cannot have same data field name as gender in population might contain irrational values.

1 Reply
el_aprendiz111
Specialist
Specialist

Hi,

optios:

1-JOIN

2 Example:


TBL_1:
LOAD * Inline
[
_Genero,Population
AZ,123
SX,159
DC,753
FV,951
GB,357
HN,953

]
;


TBL_2:
LOAD *, Lookup('Population','_Genero',Genero,'TBL_1') As Field_TBL_1;
LOAD * Inline
[
Genero,Dat
AZ,1 MAR
SX,2 JAN
DC,3AUG
Fp,5 DEC
]
;

EXIT Script;