Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

sajad_manzoor
New Contributor III

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 

Tags (4)
1 Solution

Accepted Solutions

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

HI

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

3 Replies

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

HI

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

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

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
New Contributor III

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

Thanks   MayilVahanan

Community Browser