Hello,
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’)
Regards,
Phil Bancroft
Hello,
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’)
Regards,
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.
Regards,
Khizar