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

• diponkar.paul

  SSC-Addicted

  Points: 425

  More actions

  November 12, 2020 at 12:00 am

  #3806944

  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.

• venureddy

  Newbie

  Points: 1

  More actions

  January 28, 2022 at 11:56 am

  #3978288

  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.