topic Re: How to replace rows in column1 with column2 if values in column1 are NULL, with Dataflow? in Dataflow https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3877535#M2834 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="702157" data-lia-user-login="alee023" class="lia-mention lia-mention-user">alee023</a>&nbsp;<BR />Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.</P> Tue, 30 Apr 2024 03:24:30 GMT Anonymous 2024-04-30T03:24:30Z How to replace rows in column1 with column2 if values in column1 are NULL, with Dataflow? https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3876661#M2824 <P>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.</P> Mon, 29 Apr 2024 18:48:58 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3876661#M2824 alee023 2024-04-29T18:48:58Z Re: How to replace rows in column1 with column2 if values in column1 are NULL, with Dataflow? https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3876706#M2825 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="702157" data-lia-user-login="alee023" class="lia-mention lia-mention-user">alee023</a>&nbsp;<BR />Thanks for using Fabric Community.<BR />You can create a new column using the condition as below:<BR /><BR />I have a sample table which has a column named countryRegionCode with null values.<BR /><BR /></P> <P><img /></P> <P><BR />If you consider the Col2 as isPaidTimeOff, then the condition would be as follows:<BR /><BR /></P> <P><img /></P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> <P><img /></P> <P><BR />Then the new column will get generated as follows:<BR /><BR /></P> <P><img /></P> <P><BR /><BR />Hope this helps. Please let me know if you have any further queries.</P> <P><BR /><BR /></P> Mon, 29 Apr 2024 19:12:01 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3876706#M2825 Anonymous 2024-04-29T19:12:01Z Re: How to replace rows in column1 with column2 if values in column1 are NULL, with Dataflow? https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3877535#M2834 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="702157" data-lia-user-login="alee023" class="lia-mention lia-mention-user">alee023</a>&nbsp;<BR />Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.</P> Tue, 30 Apr 2024 03:24:30 GMT https://community.fabric.microsoft.com/t5/Dataflow/How-to-replace-rows-in-column1-with-column2-if-values-in-column1/m-p/3877535#M2834 Anonymous 2024-04-30T03:24:30Z