Solving for literal null values

Clinton Jones
Clinton Jones Experian Elite
edited December 2023 in General

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!



Tagged: