CODEWITHSUNDEEP
azureazure-data-factory
user19625351
user19625351

Reputation:

can we select columns which starts with particular string in ADF Dataflow?

So I have a data and I have to select columns which starts with "Rain" using dataflow. Is there a way we can do that?

Upvotes: 0

Views: 1605

Answers (1)

Saideep Arikontham
Saideep Arikontham

Reputation: 6104

You can achieve this using select transformations. The following is a demonstration of how you can achieve this.

  • The following are the columns taken as a the source.

enter image description here

  • After adding the source, use select transformation. In this, remove all the mapped columns. Click on Add Mapping -> Rule-based Mapping

enter image description here

  • In this rule-based mapping, you can use the condition to select the column names starting with Rain. The rule is startsWith(name,'Rain') and the output column name is $$ (indicates the same name as source column name)

enter image description here

  • You can inspect the output where you can see that only column with name starting with Rain are selected.

enter image description here

Upvotes: 1

Related Questions