topic Re: Unqualified a field in QlikView

Unqualified a field

Wed, 18 Jun 2014 13:45:48 GMT

Hello everybody,

I had a problem

I had a table called CLIENT and qualify it , i have a field called "CodeClient" but i don't want to qualify it. All the table except it

This is the code:

qualify*;

Rename Table CLIENT to CLIENT2;

CLIENT:

load * resident CLIENT2;

Drop table CLIENT2;

unqualify [CLIENT.CodeClient];

Thats not work ! Thanks for your help

Re: Unqualified a field

its_anandrjs — Wed, 18 Jun 2014 13:48:30 GMT

Try like

qualify*;

Rename Table CLIENT to CLIENT2;

unqualify CodeClient; //Unqualify will be used before the table load then it works

CLIENT:

load * resident CLIENT2;

Drop table CLIENT2;

Re: Unqualified a field

Anonymous — Wed, 18 Jun 2014 13:48:53 GMT

unqualify CodeClient;

Re: Unqualified a field

Wed, 18 Jun 2014 13:50:22 GMT

Thanks but now the field Codeclient not appear in the table

Re: Unqualified a field

maxgro — Wed, 18 Jun 2014 13:50:59 GMT

maybe

qualify*;

unqualify [CodeClient];

Rename Table CLIENT to CLIENT2;

CLIENT:

load * resident CLIENT2;

Drop table CLIENT2;

Re: Unqualified a field

Wed, 18 Jun 2014 13:53:06 GMT

I'll test thanks

Re: Unqualified a field

Wed, 18 Jun 2014 13:54:25 GMT

Thank you but CodeClient not appear..

Re: Unqualified a field

its_anandrjs — Wed, 18 Jun 2014 13:55:53 GMT

Try with this but check manual field is avilable or not but it is strange also.

qualify*;

unqualify CodeClient;

Rename Table CLIENT to CLIENT2;

CLIENT:

load * resident CLIENT2;

Drop table CLIENT2;

Re: Unqualified a field

its_anandrjs — Wed, 18 Jun 2014 14:01:42 GMT

Check this small example and it works my end

qualify*;

unqualify CodeClient;

CLIENT:

load * Inline

[

CodeClient

];

Rename Table CLIENT to CLIENT2;

And also your Rename script line is in wrong place put after the table load see for your table

----------------------------------------------------

qualify*;

unqualify CodeClient;

CLIENT:

load * resident CLIENT2;

Rename Table CLIENT to CLIENT2;

Drop table CLIENT2;

-----------------------------------------------------

Re: Unqualified a field

Anonymous — Wed, 18 Jun 2014 14:07:09 GMT

Hi,

I tried with this sample data, It is working fine for me:

Temp:

Load * Inline

[

Field1, Field2, Field3

P, 100, 34

Q, 200, 12

R, 250, 56

S, 550, 21

];

Qualify*;

Rename Table Temp to Temp1;

UNQUALIFY Field1;

Temp3:

Load * Resident Temp1;

drop table Temp1;

Re: Unqualified a field

Wed, 18 Jun 2014 14:09:34 GMT

Just rename field CLIENT.CodeClient when you are done with Qualifying and creating the table. Make sure to UNQUALIFY *; after you are done with the table import to avoid any table suffix to field names.

Re: Unqualified a field

maxgro — Wed, 18 Jun 2014 14:16:48 GMT

why not?

CLIENT:

Load

CodeClient,

Pick(Ceil(3*Rand()),'X','Y','Z') as Dim3,

Round(1000*Rand()*Rand()*Rand1) as Expression1;

Load

Rand() as Rand1,

IterNo() as CodeClient

Autogenerate 1000

While Rand()<=0.5 or IterNo()=1;

qualify*;

unqualify [CodeClient];

Rename Table CLIENT to CLIENT2;

CLIENT:

load * resident CLIENT2;

Drop table CLIENT2;

Re: Unqualified a field

rwunderlich — Wed, 18 Jun 2014 14:25:21 GMT

Follow the QUALIFY with an unqualify before loading the table.

qualify*;

unqualify CodeClient'

Then load the CLIENT table from source.

-Rob