Write Null instead of Blank

From Starfish ETL
Revision as of 16:28, 30 March 2015 by Jkuehlthau (talk | contribs)
Jump to navigation Jump to search

By default, Starfish will write a blank, "", value to the destination. If you instead want to write Null, you must use a script for this.

Function ScriptedField
  ScriptedField = "@@ORG:law_firm_c@@"
  if len(ScriptedField) = 0 then
    ScriptedField = vbNullChar
  end if
End Function