topic Re: Crush and new table in QlikView

Crush and new table

Wed, 18 Jun 2014 08:21:11 GMT

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.

Re: Crush and new table

MK_QSL — Wed, 18 Jun 2014 08:32:38 GMT

Try Qualify * instead of * Qualify 🙂

Re: Crush and new table

Wed, 18 Jun 2014 08:34:16 GMT

Excuse me it was Qualify * ;

I made a mistake when i wrote this topic

Re: Crush and new table

Wed, 18 Jun 2014 08:38:22 GMT

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

Re: Crush and new table

Wed, 18 Jun 2014 08:43:56 GMT

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

Re: Crush and new table

Wed, 18 Jun 2014 08:50:26 GMT

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

Re: Crush and new table

Anonymous — Wed, 18 Jun 2014 08:51:30 GMT

You can use RENAME command to change the field name.

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

Thanks