Unqualified a field

[#1]

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

[its_anandrjs]

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;

[Anonymous]

unqualify CodeClient;

[#4]

Thanks but now the field Codeclient not appear in the table

[maxgro]

maybe

qualify*;

unqualify [CodeClient];

Rename Table CLIENT to CLIENT2;

CLIENT:

load *  resident CLIENT2;

Drop table CLIENT2;

[#6]

I'll test thanks

[#7]

Thank you but CodeClient not appear..

[its_anandrjs]

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;

[its_anandrjs]

Check this small example and it works my end

qualify*;

unqualify CodeClient;

CLIENT:

load * Inline

[

CodeClient

a

b

c

];

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;

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

[Anonymous]

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;