Forum Discussion

alee023's avatar
alee023
Frequent Visitor
2 years ago
Solved

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

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.
Dataflows
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

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