Look up values from similar results of different dimensions

[#1]

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.

[el_aprendiz111]

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;