how to map field with two different field names

[#1]

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?

[#2]

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

[#3]

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;