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.



2 Replies

  • 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.