Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
How can I replace missing value of a column with value of other column using a prepare ?
Hi @Linda97,
You can use a formula step with a coalesce function as shown below.
I used coalesce(null, "string") where the column with the empty cells is null and the column with the values you want to replace the empty cells with is "string".
Please let us know if you have any questions.
Thanks!
Jordan
โ