Dataflow expression builder - Filter Does Not Contain

Question

Hi

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

Paul

Answer 1

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:

**Sample filtered Data
**

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.