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

[sajad_manzoor]

*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 · Accepted solution]

HI

Try with Qualify concept

Qualify *;

Load * from tablename;

Unqualify *;

[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]

Thanks   MayilVahanan