Workbench handling of Null values

jstan
jstan Dallas, TX 🟠

Hi, I realize I can add a transform in Workbench to replace a null value with a value on a field by field basis, or write it in the SQL, but I would like the ability to replace null values in bulk for a workbench job based on the datatype of the field. 

 

For example, all strings with a null value get the a specified value like 'Null' or 'Blank'.  All numbers with a null value could be set to 0.  All dates could be set to a certain date, etc.

 

When we have wide datasets, there really is no easy way to do all of this... we have over 1000 workbench jobs and the average width is probably 30-40 fields.

 

Thanks,
Josh

Tagged:
0
0 votes

· Last Updated

This discussion has been closed.