Loading CSV files with dates in the name of the file into Workbench
Hi,
I need to create an automated job to upload files using workbench. The job runs daily and picks the latest CSV file with the date in the file name. So for example, if the job runs today it should know the file to upload is ABC_11122019.csv, similarly tomorrow it will be ABC_11132019.csv.
Hope it makes sense. I am new here so not sure if I am posting in right place. Advice me on how to setup such a process.
Comments
-
Hi there,
Yes, this can be done. When setting up the job you will need to set the reader type to "CSV" and the transport type to "FTP/SFTP File Provider".
Once the job is in workbench under the configure section you will need to edit the source section. you will enter your details in the Remote File box. there is a pop up there that will guide you with the correct formatting.
I hope this moves you forward.
Jarvis
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 620 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 742 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive