What does "Lock Data Type" mean in Workbench 4?
I've found importing Excel datetime values a bit tricky and am using Workbench to fix glitches.
The values are formatted in a way that works correctly on most columns, but some still come through as text. So I use the Schema tab to set the field type to DATETIME which seems to do the trick.
I've noticed an attribute on the right called "Lock Data Type" that I can't find mentioned in the docs or here on the Dojo. The screenshot below shows the attribute I'm talking about on the far right:
Can someone tell me what ticking this box does? My hope is that it force Workbench to stick with the assignment. So that if for example, I selected DATETIME and tick the box, Workbench will always try to read that column as DATETIME and never treat it as TEXT.
Note: I've got a system that produces datetime columns in Exel. Most are treated as datetime, some come through as text. Same sort of date, identical code to do the convertion, everything looks the same in Excel. So. I want to lock this down in Workbench and make sure that the datetime values consistently go through as datetimes.
Thank you.
Best Answer
-
Hi,
From the tests I've made with this feature, it does force workbench to use the selected datatype or use the error handling selected operation if the data cannot be converted to the selected datatype.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0
Answers
-
Hi,
From the tests I've made with this feature, it does force workbench to use the selected datatype or use the error handling selected operation if the data cannot be converted to the selected datatype.
Hope this helps.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.0 -
Thanks or the confirmation.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 600 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 688 Beast Mode
- 43 App Studio
- 38 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive