Crush and new table

[#1]

Hello, here's a question that may seem relatively simple

I have a number of imported table using the statement:

binary [test.qvw];

This test.qvw imports a table called CLIENT but is not qualified

I would just have the same CLIENT table but qualified so I tried

* Qualify;

CLIENT:

load * CLIENT resident;

And nothing moves  I have to create a table CLIENT2  and now it's OK

* Qualify;

CLIENT2:

load * CLIENT resident;

Ok for that but I want my table CLIENT and not CLIENT2 therefore crush the old unskilled and qualify calls because I have code that depends on CLIENT no CLIENT2!

thank you very much and sorry for my bad english.

[MK_QSL]

Try Qualify * instead of * Qualify 🙂

[#3]

Excuse me it was Qualify * ;

I made a mistake when i wrote this topic

[#4]

Hi

Qualify *;   will qualify all fields following tihis statement and qualify them with the last table label found.

if you use

CLIENT:

LOAD * Residnet CLIENT

QV interprets both tables as the same and mix the second one on the first one  ...so no change

you have to go thru an other table (client2)   or change CLIENT by Tmp  and CLIENT2 by CLIENT.

You can also rename CLIENT2 as CLIENT but drop table CLIENT before

best regardss

Chris

[#5]

Yeah super Chris the change table name is ok!

But an other problem, the fields on the CLIENT table starts by CLIENT2.code for example!

Thanks you

[#6]

Yes

so rename fields can be long, the best is you do

UNQUALIFY *;

Tmp:

LOAD * from ....

QUALIFY *;

CLIENT:

LOAD * resident Tmp;

drop table Tmp;

Chris

[Anonymous]

You can use RENAME command to change the field name.

RENAME Field [CLIENT2.code] to [CLIENT.code];

Thanks