Dataflow expression builder - Filter Does Not Contain

Paul Taylor 20 Reputation points


Is there a filter expression in Dataflow expression builder, where I can filter out data in a column where the data contains the word "Click" ?

In SQL I would normally type

Column Name Not Like '%Click%'

Thanks In Advance


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,053 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 43,597 Reputation points Microsoft Employee

    Hi @Paul Taylor ,

    Welcome to Microsoft Q&A forum and thanks for reaching out here.

    Yes, you can achieve the same using below expression in Filter transformation in Mapping data flow:

    Sample expression:

    not(like(FIRSTNAME, '%mes%'))

    Sample Source Data:
    User's image

    **Sample filtered Data
    User's image

    User's image

    Hope this helps.

    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful