topic Re: Qualify Name change in QlikView

Qualify Name change

priyarane — Wed, 15 Nov 2017 12:22:52 GMT

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

Re: Qualify Name change

Chanty4u — Wed, 15 Nov 2017 12:26:39 GMT

try unqualify *;

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 12:29:41 GMT

it won't work as columns are already qualified.

Re: Qualify Name change

Chanty4u — Wed, 15 Nov 2017 12:32:50 GMT

How come? where is your script?

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

Re: Qualify Name change

Anil_Babu_Samineni — Wed, 15 Nov 2017 12:38:09 GMT

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

Re: Qualify Name change

prma7799 — Wed, 15 Nov 2017 12:39:07 GMT

Try to give alias name using resindent ..

Re: Qualify Name change

Clever_Anjos — Wed, 15 Nov 2017 12:41:44 GMT

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

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 12:43:21 GMT

I need to use qualify some reasons

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 12:47:21 GMT

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

Re: Qualify Name change

Clever_Anjos — Wed, 15 Nov 2017 12:59:20 GMT

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

Re: Qualify Name change

HirisH_V7 — Wed, 15 Nov 2017 13:04:04 GMT

Hi,

check out,

QUALIFY *;
 T1:
 LOAD * INLINE [
 A, B
 ];
 
 Temp:
 LOAD * INLINE [
 A, B
 ];
 UnQUALIFY *;
 
 T2:
 load Temp.B,
 Temp.A as A
 Resident Temp;
 
 Drop Table Temp;

You can rename by calling qualified table into resident and rename it.

-Hirish

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 13:06:54 GMT

Thanks Clever for your efforts, but this loop is changing for Tab2 only, I am trying to change code, can you please check once again from your side

Re: Qualify Name change

Clever_Anjos — Wed, 15 Nov 2017 13:12:13 GMT

Which are the names from your another tables column names?

It seems correct to me here

Re: Qualify Name change

Clever_Anjos — Wed, 15 Nov 2017 13:13:55 GMT

Check here, I could reproduce the issue

Re: Qualify Name change

Clever_Anjos — Wed, 15 Nov 2017 13:19:42 GMT

This below will check all tables, BUT if you have for example Tab1.Num and Tab.Num, you can´t rename both to Num, because of this

Rename field Tab1.Num to Num; // Will succeed ONLY it you don´t have a Num Field

Rename field Tab2.Num to Num; // Will will FAIL, since last row have created a Num field

For i = 0 to NoOfTables()-1

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

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 13:23:14 GMT

QUALIFY *;
Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

Table4:
LOAD * INLINE [
Key1, Value1
J, 100
K, 200
L, 100
];

Table5:
LOAD * INLINE [
Key1, Value1
P, 200
Q, 300
R, 400
];

Table6:
LOAD * INLINE [
Key1, Value1
X, 2000000
Q, 300
R, 400
];

Table7:
LOAD * Inline [
Key1, Value1
M, 500000
];

UNQUALIFY *;

Re: Qualify Name change

priyarane — Wed, 15 Nov 2017 14:50:41 GMT

not working as expected

Re: Qualify Name change

HirisH_V7 — Wed, 15 Nov 2017 15:11:24 GMT

Did u try that clever's suggestion.

Re: Qualify Name change

rwunderlich — Wed, 15 Nov 2017 15:44:11 GMT

Perhaps you could explain why you need to use qualify and then completely undo the qualify?

-Rob

Re: Qualify Name change

priyarane — Thu, 16 Nov 2017 03:00:39 GMT

Hi Rob, I am doing partial load after the unqualify for a table....replace load tab1.key, tab1.value from my excel