Rule based mapping - Azure data factory

Vivek Komarla Bhaskar 756 Reputation points


I am trying to use rule-based mapping on my input schema, which is a CSV file. For some reason, I can't achieve what I want.

This is the screenshot of my input schema, as you can see I have columns that contain %Concurrent% & %Plays%. What I'm trying to do is filter the columns that contain %Concurrent%, but as you can see in my screenshot, it's not working.

Screenshot 2023-03-20 at 11.11.15 am

Screenshot 2023-03-20 at 11.12.00 am

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

Accepted answer
  1. Suba Balaji 8,466 Reputation points


    Try to use locate function instead of like function in select transformation.

    locate('concurrent', lower(name))!=0

    This will give all the columns that have concurrent in it.

    Please watch this video from 8:00, for reference. Feel free to reach out for any other question reg this.

0 additional answers

Sort by: Most helpful