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

  • Question

  • Hi All,

    I have columns like address1, address2, address3, City. if address1 column wont have any value it should replace with address2 column. 

    How can we achieve it in Azure data factory, requesting you to suggest.

    Thanks in Advance!!



    • Moved by Dave PatrickMVP Wednesday, December 23, 2020 1:41 PM looking for forum
    Wednesday, December 23, 2020 6:13 AM


  • I'd try asking for help over here.

    azure-data-factory - Microsoft Q&A



    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    • Proposed as answer by Leon Laude Wednesday, December 23, 2020 2:06 PM
    • Marked as answer by Dave PatrickMVP Wednesday, December 30, 2020 9:40 PM
    Wednesday, December 23, 2020 1:41 PM