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
Categories
- 10.6K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 100 Apps
- 703 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 22 お知らせ
- 63 Kowaza
- 296 仲間に相談
- 649 ひらめき共有