Additional field in a table with fix value

[Anonymous]

Hi,

in a QlikView-table i want to have one additional field with constant value. How can i integrate a fixed attribute.

fieldname [Additional field]

value: test

LOAD

month,

structure_name, 

...

[Additional field]

FROM;

Regards

Stefan

[salto]

Hello,

just add the fieldname in the LOAD:

LOAD

month,

structure_name,

...

'test' as [Additional field]

FROM;

Hope this helps!

[CELAMBARASAN]

Try this

LOAD month,

     structure_name,

     location_name,

     location_class,

     cost_eur,

     largest_case,

     comment,

     ncc_focus,

     data_evalution,

     1000 AS NewField //if it is a string 'String' AS NewField

FROM

D:\Projekte\QlikView\qk01.xlsx

(ooxml, embedded labels);

[jpapador]

In your load script just do

'Test' as [Additional Field]

[rustyfishbones]

you can add a new field like this. So you will get a field with Value in each

[salto · Accepted solution]

PFA the example.

Hope this helps!