Discussion Board for collaboration related to QlikView App Development.
Due some reason I am using Qualify* for many tables and after qualify and Unqualify, I am trying to get original names.
for ex I have fields like
how can I rename them like A,B,C... in script
Remove Qualify statement then? It will resolve issue. Not sure why are you used Qualify and again Rollback needed? Can you explain the logic behind
This script will iterate over all tables and all columns creating a renaming table
Any table named Tab*.name will be renamed to 'name'
For i = 1 to NoOfTables()
Let tb = TableName(i);
For j = 1 to NoOfFields(TableName(i))
let col = FieldName(j,tb);
if col like 'Tab*' then
load '$(col)' as from , SubField('$(col)','.',-1) as to AutoGenerate 1;
Mapping load * Resident renamingtable;
drop Table renamingtable;
RENAME Fields using map;
Be carefull with synthetic keys after that