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

Question

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

Answer 1

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!