Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load
a
b,
c
from path
then
Load
a
b,
c,
left(c,3) as newfield,
right(a,3) as newfield,
from path
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
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