Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
just add the fieldname in the LOAD:
LOAD
month,
structure_name,
...
'test' as [Additional field]
FROM;
Hope this helps!
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);
In your load script just do
'Test' as [Additional Field]
you can add a new field like this. So you will get a field with Value in each
PFA the example.
Hope this helps!