Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi qlikss,
I have 2 fields.
A & B
A B
1 5
2 0
0 4
I want to create third column as comment
As
If A=0, A is zero if B=0, B is zero
Final table should look like this
A B comment
1 5
2 0 B is zero
0 4 A is zero.
Someone help me with code
if(A=0 or B=0,'zero') as comment
like
load *,if(A=0 or B=0,'zero') as comment inline [
A,B
1,5
2,0
0,4
];
output: