Rename Filename on appending report from Workbench
Weekly I am appending the reports using workbench. I want to rename the Filename column into week number so that I could use this for my Week Over Week analysis. For example: my report names are "Jan 10", "Jan 17" and so on and Filename column generated as C\:work\Jan 10.xlsx. I want this filename to be look like "Jan 10", "Jan 17" and so on.
Could you please suggest how can we do that. Attached is a screen shot.
Thanks for your help!
Comments
-
Hi @user033540
You could utilize a calculated field transform on your workbench job to attempt to parse out the characters from your filename field to leave only the formatted date.
Another option is to leave it as is and use a view (Beta) or Data Flow to calculate it after it's been ingested into domo and use this new data set in place of your workbench dataset.
You can utilize a combination of LEFT() and RIGHT() functions to trim the start and end of your file name string assuming it's in the same format every time.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive