Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to get both tables columns

Hi,

I have two tables in different databases but the column names are same when I am trying to reload it is getting Field names must be Unique how to sort this problem can anyone help me.

16 Replies
Highlighted
Not applicable

but I have more than 70 columns in that It's difficult to rename all the columns right?

Highlighted
MVP & Luminary
MVP & Luminary

HI,

Can you attach sample script? It helps in understanding.

Regards,

jagan.

Highlighted
MVP
MVP

I think you can use QUALIFY keyword like:

Qualify *;

Load A,B from ....;

Load A,B from  .....;

Highlighted
Not applicable

How to use this Qualify am getting error?

Highlighted
Not applicable

can you tell me How can i add script as it contains vast data.

Highlighted
MVP
MVP

Ex:

qualify *;

unqualify TransID;    // If you want a certain one not to qualify, else remove this

select * from tab1;

select * from tab2;

select * from tab3;

Only TransID will be used for associations between the tables tab1, tab2 and tab3.

Highlighted
Not applicable

I am trying to use as below it's not working

Qualify Table1;

Table2:

load colu1,

colu2,

etc

from T_tab.qvd

Highlighted
MVP
MVP

Don't use table name for qualification. use qualify *; the tables names would be prefixed with the field names automatically.

Qualify *;

load colu1,

colu2

from T_tab.qvd

will generate like T_tab.colu1, T_tab.colu2 fields.

Highlighted
Not applicable

How to get this?