azure data factory

Anandazure 46 Reputation points
2021-10-01T08:57:52.513+00:00

insert into the ERPUID_PPL column in destination table

logic is:
CASE
WHEN[ERP]='SAP ITT' THEN[AU-CC] ELSE[ERP_UID]

HOW TO ACHIEVE THIS USING DERIVED COLUMN IN DATA FLOW AND HOW TO WRITE LOGIC FOR CASE STATEMENT IN EXPRESSIN BUILDER

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,650 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,073 questions
0 comments No comments
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2021-10-01T23:39:14.517+00:00

    Hi @Anandazure ,

    Thanks for using Microsoft Q&A forum and posting your query.

    Assuming [ERP], [AU-CC] and [ERP_UID] as column names, then your case statement in expression builder should be:

    case (            
    ERP =='SAP ITT', AU-CC,  
      ERP_UID   
    )  
    

    If [AU-CC] and [ERP_UID] are static values (not columns), then you case statement should be as below.

    case (            
        ERP =='SAP ITT', 'AU-CC',  
          'ERP_UID'   
        )  
    

    Here are couple more examples for better understanding
    True case:

    • case(10 + 20 == 30, 'dumbo', 'gumbo') ->This will return 'dumbo' as the condition 10+20==30 is true
    • case(10 + 10 == 30, 'dumbo', 'gumbo') -> This will return 'gumbo' as the condition 10+10==30 is false

    Here is a demonstration video on how to write case statement in Mapping data flow expression builder. Splitting Arrays and Case Statements in ADF Data Flows

    Hope this helps. Do let us know if you have further query.

    ----------

    • Please don't forget to click on 130616-image.png and upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful