Transforming Datetime
OK so this should seem simple enough: I have a csv file with lots of datetime fields. The values have no seperator and I am transforming for each. Example of typical value :
"20141126152526000" so... I have it set
YYYYMMDDHHMMSSfff. on 500 test records each of the datetime fields are causing an error. So the question is should the custom datetime transform work or is it better to just get the data into DOMO and then do the transformation within Dataflow?
Comments
-
Where are you entering the "YYYYMMDDHHMMSSfff" value to parse the dates? I'm not sure I'm aware of a place in Workbench to specify how a date should be parsed.
As you noted, this is fairly straightforward to accomplish in a DataFlow, so that's probably the route I would take.0 -
in the WB Transform.
WB v4
select the job
select "transforms"
select "Add New" from the ribbon
select "Custom Date Format"
you then get a UI with 2 inputs, one for the date columns to transform , the next with the custom format specification(much like an excel custom date format). i guess after reading the documentation it is still not clear to me if the WB is expecting certain/accepted date delimiters (i.e. "/" or "," or ":" ) to seperate the parts of the date field.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 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