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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 434 Beast Mode
- 22 Variables
- 511 Automate
- 114 Apps
- 389 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive