How to replace rows in column1 with column2 if values in column1 are NULL, with Dataflow?

[alee023]

I have two columns in Dataflow Gen2, and would like to use column 2's values whenever column 1 has a NULL. If there is no replace feature for this, I don't mind creating a new column.

[Anonymous · Accepted solution]

Hi @alee023 
Thanks for using Fabric Community.
You can create a new column using the condition as below:

I have a sample table which has a column named countryRegionCode with null values.

If you consider the Col2 as isPaidTimeOff, then the condition would be as follows:

Then the new column will get generated as follows:

Hope this helps. Please let me know if you have any further queries.

[Anonymous]

Hi @alee023 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.