Sign in · Register

Removing value (NULL) from Excel spreadsheets

zydrondzydrond Experian Employee
in General discussion

Hi,

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.

Many thanks

Comments

  • Clinton JonesClinton Jones Experian Elite

    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

    1. A custom file parser
    2. A workflow TRANSFORM step that replaces the 'null' strings - laborious if you have many columns that contain the 'null'
    3. A custom workflow step that replaces the 'null' strings - the professional services teams in ANZ have produced such a thing

    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.

Sign In or Register to comment.