How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

  • Comments posted to this topic are about the item How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

    “We're entering a new world in which data may be more important than software.”- Tim O'Reilly
    I love to work with data and try to capture my learning through the blog post.

    I have been working and studied in different Geo location includes Canada, Denmark, UK, Sweden.

  • Hi

    I have derived columns in azure data flow for one derived column i wrote a expression as case statement case(or(Salary == 0 , Salary <20000) , 'Low',

    or(Salary >= 20001 , Salary < 40000),'Medium',

    Salary >= 40001  ,'High')

    for this expression i am not getting High for greater than 40000 also i am getting Medium

    can you please help me

    Attachments:
    You must be logged in to view attached files.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply