Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sajad_manzoor
Partner
Partner

How to avoid creating joins(links) between tables, despite some common fields

*I have two tables,

*both have same structure and column names,

*both the tables contain more than 500 columns with same names.

*I want to import both tables in QV , and keep them separate (No links between them) .

*since, i cannot create column alias as i have no. of columns

Is there any way to keep my tables separate as islands 

1 Solution

Accepted Solutions
MayilVahanan

HI

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

Thanks & Regards,
Mayil Vahanan R

View solution in original post

3 Replies
MayilVahanan

HI

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

Thanks & Regards,
Mayil Vahanan R

View solution in original post

CELAMBARASAN

Yes you have to use Qualify here.

If you need any link using a single field then use

Qualify *;//Qualifies all the field with their table name

UnQualify FieldName;//UnQualifies the given field name alone

Celambarasan

sajad_manzoor
Partner
Partner
Author

Thanks   MayilVahanan