Solving for literal null values

Clinton Jones

Depending on the source that you are working with, you may find that you actually have literal nulls in your data, this is a common results from SQLServer sqlcmd exports to CSV.

You'll be able to easily determine whether you have literal nulls by running a profile on your data, you may not easily detect this in the preview and configure screen.

You can resolve for this with a custom file parser but you can also deal with this by making your first workflow step in a given workflow, a clean up step that simply uses a replace function to replace the string "Null" with the null function.

Note that if you don't choose the function, itself, signified by a beaker symbol, you'll be replacing the NULL string with yet another string!