Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i am new to qlikview
How to make operations like adding new column names by writing conditional statements on existeing fields in the same table by inline
Hi rgv,
Table1:
Load * [
Field1,Field2,Field3
a,b,c
d,e,f
g,h,i
j,k,l
];
Table2:
Load
Field1,
Field2,
Field3,
if(Field1='a' or Field2='h',1,0) as NewField
Resident Table1;
This is how you can put condition and make a new field for inline tables
If you have the code, just hit the hammer
And complete the wizard with the new column data.
Or, just put a "," to the last field name and complete the data.
you can join the tables
// existing table
a:
load rowno() as text1, 'new' & rowno() as newcolumn autogenerate 5;
// inline table
right join (a)
load * inline [
text1 ,text2, number1, number2, number3
1 , b , 1, 2 , 3
2 , d , 4 , 6 , 5
12 , f , 7 , 8 , 9
];
Below link may help you ....
Hi rgv,
Table1:
Load * [
Field1,Field2,Field3
a,b,c
d,e,f
g,h,i
j,k,l
];
Table2:
Load
Field1,
Field2,
Field3,
if(Field1='a' or Field2='h',1,0) as NewField
Resident Table1;
This is how you can put condition and make a new field for inline tables
thankyou SaumyaShah its working
Thanks