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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 111 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 782 Beast Mode
- 76 App Studio
- 43 Variables
- 738 Automate
- 186 Apps
- 473 APIs & Domo Developer
- 65 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 138 Manage
- 135 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive