Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add an empty column to a table

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

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

You can add an empty column to a table doing:

Select

     ...

     '' as newColumn

     ...

Or

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

View solution in original post

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

You can add an empty column to a table doing:

Select

     ...

     '' as newColumn

     ...

Or

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

ashfaq_haseeb
Champion III
Champion III

Try below

LOAD * INLINE [

    Month,Name

    Jan

    Feb

    Mar

    Apr

    May

    Jun

    Jul

    Aug

    Sep

    Oct

    Nov

    Dec

];

While loading from DB

load

A,

B,

'' as C

from abc;

Regards

ASHFAQ

PradeepReddy
Specialist II
Specialist II

Try this..

Load

     Field1,

     Field2,

     Field3,

     ''  as Field4

     ..

From

     ...

Regards,

Pradeep

Not applicable
Author

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 !