Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
*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
HI
Try with Qualify concept
Qualify *;
Load * from tablename;
Unqualify *;
HI
Try with Qualify concept
Qualify *;
Load * from tablename;
Unqualify *;
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
Thanks MayilVahanan