Add an empty column to a table

[#1]

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

[alexandros17 · Accepted solution]

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]

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]

Try this..

Load

     Field1,

     Field2,

     Field3,

     ''  as Field4

     ..

From

     ...

Regards,

Pradeep

[#5]

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 !