Forum Discussion
Data Flow-Funcktion
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 fi...
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" ) ) ) )