Working With Excel Files Where Sheets Change Names
jwheeler_liveops
Member
in Connectors
I receive a sheet from a client via SFTP every week where the name of the sheet changes with every new workbook. This means in order for Domo to ingest the file, it is my understanding that the settings of the SFTP Excel connector would need to be updated weekly. Is there a way to apply regex or some other method to work with sheets whose name changes?
0
Comments
-
Just to be clear, does it have multiple sheets?
The sheet name is optional so if it is the only sheet, or first sheet, then you can just leave that field blank.
**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"0 -
This does have multiople sheets.
The solve here is likely not going to be with Domo, but rather to have the client change how they name sheets, or manipulate the sheet names in some pre processing step.
0 -
Ok, I think you are right. There will have to be something done to the file to load it. You might consider Domo Workbench which can integrate with an external script (vb script for example). Workbench can run the script, which would download from the SFTP site and extract the sheet you want, and then upload the results into Domo. Either way, good luck!
**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"0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive