Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
Hi @alee023
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.