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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive