Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
i need to create a column as
where ever A column data is null then i should be getting value of A and if A columns data is not null then i should get A columns data only.
For that i used isnul function but seems it is not bring data what i requeired
can anyone please help here
i used
if(IsNull(A),B,A)
Thanks
Can you share your script where you doing this and images with
LOAD IsNull(A),
Len(Trim(A)),
A,
B
FROM ...
Below is the script syntax:
load A,B;
SQL SELECT A,B from table1;
Screenshot of a table using this script
LOAD IsNull(A),
Len(Trim(A)),
A,
B
FROM ...
This worked for me
If((Trim(if(A='null','0'))) = '0',B, A)
Great