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

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

sajad_manzoor — Tue, 27 Aug 2013 10:31:45 GMT

*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

MayilVahanan — Tue, 27 Aug 2013 10:42:16 GMT

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

CELAMBARASAN — Tue, 27 Aug 2013 10:46:12 GMT

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 — Tue, 27 Aug 2013 10:49:19 GMT