Excel Tab Processing All In One DataSet Through ELT

Hi folks,
If working with multitab Excels we must load on tab at a time into a DS.
Some excel workbooks are generated from the source system with many tabs, so we need to create many DSs to load this excel dataset.
Β
The proposal is to create a new ETL block which leverages the Excel Connector.
The ETL block would read an excel workbook and create an output per each tab worksheet.
From here we can manipulate the data as required such as joining/union/remove duplicates etc etc...
Β
It is my opinion that such a function would really enhance Domo.
Β
this idea comes from my current situation where I have some custom reports in GA which are defined on a number of tabs within the report in a single excel workbook. alot of this data then needs to be joined against a date.
Β
cheers,
rgds,
K.
Comments
-
This would be a great help. Is there no way to accomplish this?
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 466 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 27 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 654 γ²γγγε ±ζ