Create a Time Stamp Column, using data and time, in workbench for each time the report is ran.
Hello,
I am sending over CSV files hourly, using the append update method. I want to add a "time stamp" column, using date and hour, to mark that unique file each time it is ran. So if, if the first file is sent over and processed through workbench at 3/23/2018 at 1:48PM I would like to the time stamp to reflect that for just that upload and when it runs again, at 3/23/2018 at 2:48PM, I want those records to have that time-stamp.
I know the format will be different but could someone please help. I'm using "today" but it's only giving me the data and not the time.
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,1 -
I am also interested in finding an answer to this
0 -
You can generate a timestamp in workbench by adding a transform. Add a new transform then select "Calculate Field Transform", then the calculation you need is "CURRENTEXECUTION". This places a UTC timestamp on your data set. If you what to shift the timezone then you add another transform and select "Shift Data Timezone Transform".
1 -
Is it exclusively for Domo Workbench 5? Because here on version 4.62.6715.32090 isn't working as it cannot validate the function
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 708 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive