Removing value (NULL) from Excel spreadsheets
zydrond Experian Employee
Quick question, can Aperture handle while loading a replace task for a specific set of values ?
The requirement here is to replace all the NULL from an excel spreadsheet ... before it is loaded.
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.
There is no way to auto process things like explicit strings typically generated from SQL like 'null' when loading files. However, you have a couple of options to consider around this
In the case of 2 and 3, this is not much use if you want to profile the data after loading; you're reduced to having to use a profile step in a workflow.