Automating Multiple Imports
I am very new at using workbench so sorry if this question is too stupid to even consider.
Essentially I want to pull a report for a partition of data.
For example
select * from tables where GroupType = somenumber
Instead of creating a new job for every iteration of somenumber I was wondering if I can have Workbench automatically iterate through a list of numbers to replace for somenumber.
Alternatively could I just import all the data with something like
select * from tables
And then have DOMO split it up based on GroupType after it's uploaded?
Thanks in advance.
Best Answer
-
Why do you want different imports for different grouptypes?
If you want to display charts with different grouptype values, you can bring in all the data and just filter the charts on your different grouptypes. We do that ALL the time.
It's much better to bring in large batches of data and filter on the card (or data security PDP) level. From a data manager perspective, managing lots of slivers of data would be an inefficient use of time and system resources.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Answers
-
Why do you want different imports for different grouptypes?
If you want to display charts with different grouptype values, you can bring in all the data and just filter the charts on your different grouptypes. We do that ALL the time.
It's much better to bring in large batches of data and filter on the card (or data security PDP) level. From a data manager perspective, managing lots of slivers of data would be an inefficient use of time and system resources.
Aaron
MajorDomo @ Merit Medical
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"2
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 293 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive