I would like to know by using which kind of transform I can identify NULL which is returned from my SQL to my workbench.
I want to detect NULL and replace it with 0
Can anybody help @gaurav007 with their question?
There are a couple options to detect/replace NULL values in your data.
Please let me know if that does not answer your question.
@gaurav007, did creed's reply help you out?
creed's answer is great. If you can do this in the SQL statement that will be the best and fastest way to get this done. I wanted to offer one other option just for the sake of completeness. In workbench (the current version of Wb4) you can do this with a calculated field or a search and replace transform.
A calculated field adds a new column based off the original, and you can use a formula like: IF(ISNULL(Column),0,Column)
For the search and replace, you can search for \x00 (which is a special regular expression workbench uses to represent the null value), and replace with 0.
This is really helpful - thank you!
Hi @jeremyhurren, For the search and replace function, do you know how find blank string and replace them with nulls?