Quick Select Multiple Columns in "Select Column" ?
I am wondering if there is a way to choose multiple columns quickly when using "Select Columns" in an ETL. I do not mean using Add All Columns. We do not know SQL, and we have massive DataSets with a large amount of columns (50+), but only need a mix of about half & half between 2 Datasets. Having to scroll through & choose each column one by one is VERY cumbersome. Is there a shortcut we can use to select multiple columns from the options to add all at once?
Example, I have 2 DataSets I have joined that together, contain about different 50 columns. I only want to add about 20 of them. Do I really have to pick them & add them one by one? Thank you!
Comments
-
The quickest way I found is to:
Selet all and then delete one by one. Not a great solution but a quicker option.
0 -
Many of our tables are extremely wide with a lot of columns. We spend a considerable amount of time selecting and reordering columns. There should be a feature to see ALL columns on the right pane and columns you want selected on the left with quicker ordering.
0 -
@jkuleszynski this would be good to submit as an idea in the ideas exchange
1
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 437 Beast Mode
- 23 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive