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:



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

    when column contains ‘/’ then ‘other’

    else column




    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


    Friday, September 20, 2019 6:52 AM

All replies