Remove Table name in front of the full name - not working ?

[#1]

Hi ,

I am new to qlikview.

I have used Qualify and UnQualify statements to avoid unnecessary joins on the fields,

which append table name in front of the fields name.

At the end in final table,

we have all the fields with table name in front of that.

we want to remove that piece and would like to get only field name.

we have tried to use Rename Field command and AS statement in Load,

but, it's not working.

any suggestions ?

thanks in advance for help.

[maxgro]

in my test script rename is working:

QUALIFY *;

t:

load * inline [

a,b

1,2

1,3

1,4

];

RENAME field t.a to a, t.b to b;

[#3]

it's not working.

[#4]

Hi Hailey,

The Solution provided  by Massimo is working fine in ma system too .

Can u try like this :

QUALIFY *;

UNQUALIFY a,b;

t:

load * inline [

a,b

1,2

1,3

1,4

];

UNQUALIFY *;

Thanks!!!

[maxgro]

why not, at the end of the script I have, in table viewer

[#6]

Hi,

Could you provide some sample document?

[maxgro]

attachment