Share via

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.
10,993 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nasreen Akter 10,801 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.