topic Re: Add new Column in the Loaded Table in QlikView

Add new Column in the Loaded Table

Wed, 10 Dec 2014 05:29:54 GMT

HI everyone,

I am new to qlikview i want to a a new column in the loaded script.

How can i add new field in the script.

SunilChauhan — Wed, 10 Dec 2014 05:34:01 GMT

Load

from path

then

Load

left(c,3) as newfield,

right(a,3) as newfield,

from path

Wed, 10 Dec 2014 05:35:29 GMT

Load

from t1; this is your table for example

u want add one new filed in the loaded script

load

from t1;

concatenate

load * inline

[

];

here e is the new filed

SunilChauhan — Wed, 10 Dec 2014 05:38:39 GMT

you could use preceeding load also. see below

Load

left(c,3) as newfield,

right(a,3) as newfield1,

1 as newfield3;

Load

from path