Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have two oracle table. Both the tables has industry code, but in table 1 name of the column is "IND_CODE" and another table has the column name as "INDDETAIL".
How will i map these two columns?
Hi,
Create an Alias for these columns while loading.
e.g. IND_CODE as [Industry Code]
INDDETAIL as [Industry Code]
The mapping will be done by Qlikview based on the alias [Industry Code].
-Haneesh
Hi,
If you want to join this tables, the columns need to have equals alias, and use the function join:
Ex.:
TABLE:
LOAD IND_CODE AS INDDETAIL
SQL
SELECT IND_CODE
FROM TABLE_A;
TMP_TABLE:
JOIN(TABLE)
LOAD INDDETAIL
SQL
SELECT INDDETAIL
FROM TABLE_B;