locked
How to replace values in data factory data flow? RRS feed

  • Question

  • Hello everyone, I am new at Azure data factory and want to replace some values using Azure data flow (preview). I have already combined some functions but I did not work.

    I want to do something like this in data flow:

     

    for example:

     

    case

    when column contains ‘-‘ then substring(column, charindex(‘-‘, column)+2, 2)

    when column contains ‘/’ then ‘other’

    else column

    end

     

    data:

    AA                   AA

    BB                   BB

    eew – AA        AA

    io – CC            CC

    CC                  CC

    AA/DD            other

    AA/CC            other

     

    Thank you so much for you help

    Greetings


    Friday, September 20, 2019 6:52 AM

All replies