Output 'null' from expression


How do I get Centerprise to output a null in a translation? i.e- I want to strip any “N/A” from the external source and replace with null (the actual nothing, not the word ‘Null’)


Phil Bancroft

Hi Phil,

You can replace your "N/A’ values in a column from your external sources to ‘Null’ by using ‘IF ELSE’ operation in ‘Expression’ transformation.

< If(Column=“N/A”, ‘’ ,Column) >

The above expression will replace all your “N/A” values in a column by ‘Null’ (dual single quotes).

I have attached a screenshot for your reference.

Let me know if this works for you.