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

[#2]

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.

[maxgro]

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;

[rwunderlich]

Follow the QUALIFY with an unqualify before loading the table.

qualify*;

unqualify CodeClient'

Then load the CLIENT table from source.

-Rob