[Solved] Table Delivery - Setting 'Value If Null' to a variable

[c6lapsteel]

Hi All,

Does anyone know if it's possible to set 'Value If Null' to a value assigned to a variable in a Table Delivery?

Thanks,

[Opher]

I believe "Value If Null" is intended as a constant, like when you want to use -999 to indicate "unknown".  If you want to use a variable, why not define a derivation in the datastream and make the assignment there if the column is null?

Good luck,
Opher

[rmcleod]

How about set a global environmental variable in the batch file that calls decisionstream 

set null_value_key=999999

Then in the column definitions in the table delivery, put {$null_value_key} in the value if null box. If you are running  multiple catalogues in sequence, the variable will persist throughout the whole session and you wont have to change it in multiple places.

[c6lapsteel]

Excellent suggestion - thanks for your input.

Regards