Can a change be made to the “Remove Columns” Action to be less explicit?
Frequently, we’re importing flat files that have a combination of text and date columns. We usually want to get to an end dataset of just some of the text columns and the date columns pivoted.
When using the Remove Columns action, we need to specify which columns are to be removed. If some of the flat files don’t have one of these columns, an error is generated.
As I want to remove these columns, can we ignore, or be given the option to ignore generating an error where one or more columns don’t exist?