Whenever you bring in a new dataset from a table, the column names always match the field names in the database. What I would like to have is a single step where I can make a selection and it will change all the names based on a pattern.

For example, if I have column names like CUSTOMER_NAME and PRODUCT_NUMBER, I would like to make a selection and it would change all the names to be something like "Customer Name" and "Product Number". That way it will make all the field names more presentable. I would also like the option to say whenever I see something like PRODUCT_NUM, it would know to convert "NUM" to "Number".

This would save on creating a rename step for every single field.