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?

CodePudding user response：

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.

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

• 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)

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