Qualify Name change

[priyarane]

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

[Chanty4u]

try   unqualify *;

[priyarane]

it won't work as columns are already qualified.

[Chanty4u]

How come?  where is your script?

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements...

[Anil_Babu_Samineni]

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

[prma7799]

Try to give alias name using resindent ..

[Clever_Anjos]

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

[priyarane]

I need to use qualify some reasons

[priyarane]

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

[Clever_Anjos]

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