Hello everyone,
How can I replace null values in a column with a float data type in OneWeb? I need to substitute null values with 0 and apply a formula in advanced expressions.
Thanks in advance.
Hello everyone,
How can I replace null values in a column with a float data type in OneWeb? I need to substitute null values with 0 and apply a formula in advanced expressions.
Thanks in advance.
Hi
SELECT attribute_1, attribute_2,
CASE
WHEN attribute_3 is null THEN 0
ELSE attribute_3
END AS attribute_3
FROM table;
iif(attribute_3 is null, 0, attribute_3)
Could you please describe your use case in some more detail? What do you want to achieve once you have the completed the setup? Thanks!
Thank you so much
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.