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!