Discussion Board for collaboration related to Creating Analytics for QlikView.
*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
Go to Solution.
Try with Qualify concept
Load * from tablename;
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