ETL Select Columns "Shortcut"
Hello, I work with Datasets with high counts of columns. When I create ETL's where I have to Select Columns, I can be going through 150+ columns at a time to choose the columns I need. If I only have a handful to add, scrolling through the list and adding one by one is not really an issue, but when I need to add 30+, it get's very time consuming scrolling through the list over and over to add each column. Adding all columns, and then going through the list to remove the columns I don't need, takes just as long when I'm only selecting, say, 40 columns out of the 150+.
Is there a faster way to add multiple columns (30+), than going through the whole list of 150+ fields and selecting columns one by one? For example, is there a way to select multiple columns at once to add, and then once added, go down the selected list and set the properties for each?
If not, having selection boxes next to the column names, or some other way of choosing multiples to add, would be a great enhancement for future upgrades. Thank you!
Note: Due to the size of our company, count of users, and the amount of data in some of our Datasets (Millions of rows), access to Workbench is limited to our IT Dept, so I do not have access.