Hi, 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.

Hey, 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. https://youtu.be/8n83y5eobN8

Rule based mapping - Azure data factory

Accepted answer

Suba Balaji 11,186 Reputation points

2023-03-20T11:34:35.92+00:00

Hey,

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.

https://youtu.be/8n83y5eobN8
Please sign in to rate this answer.
Vivek Komarla Bhaskar 911 Reputation points

2023-03-20T12:00:29.3033333+00:00

Hi, thank you. I also have a metric related to Plays in my list of source attributes. I'm now trying to use the same expression you shared with me for Plays, but again I get no results. What is the catch here? Am I missing something?

Suba Balaji 11,186 Reputation points

2023-03-20T16:02:24.9366667+00:00

Hi Vivek, are you copy pasting the expression or typing yourself on expression builder?

Vivek Komarla Bhaskar 911 Reputation points

2023-03-21T00:24:29.9733333+00:00

Hi Subashri, That's strange, how does it matter if I copy paste when the expression is exactly the same?

Suba Balaji 11,186 Reputation points

2023-03-21T02:48:04.4566667+00:00

Did it work when you type?

Vivek Komarla Bhaskar 911 Reputation points

2023-03-24T19:03:42.3533333+00:00

Hi, @Subashri Vasudevan No it is not working. Whatever was working for _concurrent earlier, now even this is not working. Looks like some bug

Vivek Komarla Bhaskar 911 Reputation points

2023-03-24T19:45:33.1833333+00:00

Hi, @Subashri Vasdudevan It's working now. I had to turn the debug off and close and reopen the Azure data factory session, after doing this it's working alright. But still this is something that needs to be checked, it looks like a bug
Sign in to comment

Rule based mapping - Azure data factory

0 additional answers