9 thoughts on “Azure Data Factory – If Condition activity

  1. Pingback: Azure Data Factory–Copy Data Activity – Mitchellsql

  2. Pingback: Azure Data Factory–Filter Activity – Mitchellsql

  3. Great post, quick question though… don’t you need to CAST the Lookup and Get Metadata values to either Date or Integer and then compare?

    • Hey Saul! Thanks for the feedback and the link. The example that I shared in this blog post works without having to change any data types. I am really curious why your example doesn’t work and would like to recreate the problem on my end. I sent you an email with details, thanks again!

  4. Hi Mitchell,

    Thanks for the post.
    I have a question, suppose I have a dataset like a view from Azure Sql Server and in that view it has two columns of which one is a flag (0/1). I want to perform an activity A if true(1) else activity B. How can I achieve this using If Condition activity?

    Thanks in advance.

    • Hey Roy, the If Condition activity does not operate on individual rows from a dataset. However, you may want to explore ADF Data Flows, these provide you with a lot of the same functionality you may be familiar with from SSIS.

Leave a Reply to Rayis Imayev (@RayisImayev) Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s