Data Flow-Funcktion

[Anonymous]

Hello all, 

I have a problem in dataflow. we get the data in csv and doing the etl stage in dataflow. after a few steps we bring the data to the desired form. We also have a separate manual excel file (Mapping Table) that shows which region and category the BIDs are. When there is a change in our mapping table, we need to go into this function and change it manually and we want to automate this step. I would appreciate your help.

[jennratten]

Hello - I recommend that you identify the correct logic to use so that you can drive the list of columns programatically instead of having to define them manually.  For example, if the columns should be limited to those with a name of Column3 or with names that are 4 characters long and begin with B, you could do it like this:

Table.SelectColumns ( #"Prior Step Here",  List.Select ( Table.ColumnNames ( #"Prior Step Here" ), each _ = "Column3" or ( Text.Length ( _ ) = 4 and Text.StartsWith ( _, "B" ) ) ) )