Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;