topic Re: Additional field in a table with fix value in QlikView

Additional field in a table with fix value

Anonymous — Fri, 18 Oct 2013 13:55:14 GMT

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

Re: Additional field in a table with fix value

salto — Fri, 18 Oct 2013 13:58:37 GMT

Hello,

just add the fieldname in the LOAD:

LOAD

month,

structure_name,

...

'test' as [Additional field]

FROM;

Hope this helps!

Re: Additional field in a table with fix value

CELAMBARASAN — Fri, 18 Oct 2013 13:59:15 GMT

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);

Re: Additional field in a table with fix value

jpapador — Fri, 18 Oct 2013 13:59:44 GMT

In your load script just do

'Test' as [Additional Field]

Re: Additional field in a table with fix value

rustyfishbones — Fri, 18 Oct 2013 14:00:47 GMT

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

Re: Additional field in a table with fix value

salto — Fri, 18 Oct 2013 14:04:21 GMT

PFA the example.

Hope this helps!