topic Re: Add an empty column to a table in QlikView

Add an empty column to a table

Fri, 20 Jun 2014 10:02:11 GMT

Hello everyone,

I have to add an empty column to a table, what is the best method bewteen :

LOAD INLINE

[

Name

];

or add a column without any definition ?

And one more question, is it possible that the new column that I load has not a serie of :

Thank you

Re: Add an empty column to a table

alexandros17 — Fri, 20 Jun 2014 10:04:51 GMT

You can add an empty column to a table doing:

Select

...

'' as newColumn

...

Load

...

'' as newColumn

...

If you use ' ' (that is a blank) you won't have - symbol

Otherwise you can add an empty column to your chart (pivot or straight) simply adding a new expression:

E.g. write this in expression

=' '

Hope it helps

Re: Add an empty column to a table

ashfaq_haseeb — Fri, 20 Jun 2014 10:14:10 GMT

Try below

LOAD * INLINE [

Month,Name

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

];

While loading from DB

load

'' as C

from abc;

Regards

ASHFAQ

Re: Add an empty column to a table

PradeepReddy — Fri, 20 Jun 2014 10:42:07 GMT

Try this..

Load

Field1,

Field2,

Field3,

'' as Field4

From

...

Regards,

Pradeep

Re: Add an empty column to a table

Fri, 20 Jun 2014 11:47:43 GMT

Thank you for all your responses.

I haven't been able to mask the "-" by insert the column with LOAD,

But by creating an empty column in my table, with definition =' ' it works !

Thanks !