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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 778 Automate
- 190 Apps
- 482 APIs & Domo Developer
- 83 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 412 Distribute
- 120 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive