How to replace if column1 has Null with column2 which have value in Azure data factory!!

Ashok Kumar Bollineni 46 Reputation points
2020-12-23T12:35:25.103+00:00

Hi,

I have columns like address1, address2, address3, City like that, if address1 column dont have any data it should display what every data is present in address2 field. requesting you to suggest how to achieve in azure data factory.

Regards,
Ashok

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,488 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nasreen Akter 10,736 Reputation points
    2020-12-23T13:19:34.523+00:00

    Hi @Ashok Kumar Bollineni ,

    Thank you for asking this question. In the ADF, you can use coalesce(address1, address2, address3) function to achieve this (please see the screenshot). Please let me know if this helps. If it does, please don't forget to "accept the answer" and "up-vote"! Thank you!

    50816-coalesce.jpg

    5 people found this answer helpful.
    0 comments No comments