Prepare Recipe, formula. How to output null vs ""
stainlessteelra
Registered Posts: 13 ✭✭✭✭
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
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023, Circle Member Posts: 2,611 NeuronWhy do you need a column with a null value? Please explain your requirement, not the step.
-
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!