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
