Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Additional field in a table with fix value

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

1 Solution

Accepted Solutions
salto
Specialist II
Specialist II

PFA the example.

Hope this helps!

View solution in original post

5 Replies
salto
Specialist II
Specialist II

Hello,

just add the fieldname in the LOAD:

LOAD

month,

structure_name,

...

'test' as [Additional field]

FROM;

Hope this helps!

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Partner - Specialist
Partner - Specialist

In your load script just do

'Test' as [Additional Field]

rustyfishbones
Master II
Master II

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

2013-10-18_1448.png

salto
Specialist II
Specialist II

PFA the example.

Hope this helps!