Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Qualify Name change

hi Community,

Due some reason I am using Qualify* for many tables and after qualify and Unqualify, I am trying to get original names.

LIke:

for ex I have fields like

tab1.A

tab1.B

tab2.A

tab2.B

tab3.C

how can I rename them like A,B,C... in script

_Priya

22 Replies
Highlighted
Champion III
Champion III

Re: Qualify Name change

try   unqualify *;

Highlighted
Specialist
Specialist

Re: Qualify Name change

it won't work as columns are already qualified.

Highlighted
Champion III
Champion III

Re: Qualify Name change

Highlighted

Re: Qualify Name change

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Master III
Master III

Re: Qualify Name change

Try to give alias name using resindent ..

Highlighted
Employee
Employee

Re: Qualify Name change

You can rename them using this How to Rename Fields using Mapping Table

Highlighted
Specialist
Specialist

Re: Qualify Name change

I need to use qualify some reasons

Highlighted
Specialist
Specialist

Re: Qualify Name change

there are 1000 of records I have in data, so can you give your thoughts like replacing 'Tab*.' with nothing

Highlighted
Employee
Employee

Re: Qualify Name change

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

        renamingtable:

        load '$(col)' as from , SubField('$(col)','.',-1) as to AutoGenerate 1;

     endif

  Next

Next

map:

Mapping load * Resident renamingtable;

drop Table renamingtable;

RENAME Fields using map;

Be carefull with synthetic keys after that