Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add new Column in the Loaded Table

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.

3 Replies
SunilChauhan
Champion II
Champion II

Load

a

b,

c

from path

then

Load

a

b,

c,

left(c,3) as newfield,

right(a,3) as newfield,

from path

Sunil Chauhan
Not applicable
Author

Load

a

b

c

d

from t1;     this is your table  for example

u want add one new filed in the loaded script 

load

a

b

c

d

from t1;

concatenate

load * inline

[

e

];


here  e is the new filed     

SunilChauhan
Champion II
Champion II

you could use preceeding load also. see below

Load

left(c,3) as newfield,

right(a,3) as newfield1,

1 as newfield3;

Load

a

b,

c

from path

Sunil Chauhan