Prepare Recipe, formula. How to output null vs ""

stainlessteelra

Please advise how to setup a formula that outputs a null value instead of the empty string in the database.

using redshift database.

Simple example,
ColumnB:
if(isNull(ColumnA), "", ColumnA)

What do i use instead of double quotes

Turribeach

Why do you need a column with a null value? Please explain your requirement, not the step.

stainlessteelra

For later on Data Quality checks within the tool, the rule type "column values are not empty", only looks for nulls if it is run in SQL.

I can run it in the stream engine but it takes 10X the time. So i was asking to make sure we create nulls in the prepare step to make my data quality checks more timely / efficient.

Thanks!