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

how to map field with two different field names

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 Replies
Not applicable
Author

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

Not applicable
Author

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;