Workbench - Preview Schema Data Type Error
We have been trying Workbench in different computers including the main server where we will upload data to our Domo instance.
In this example, we are uploading data from a CSV file which have different data types (STRING, DATETIME, DECIMAL) and, in general, in all computers the Workbench maps the schema correctly during the preview.
On the other hand, in the main server, when we do the preview it maps everything as STRING. The problem is that when we try to change the schema from STRING to DATETIME or DECIMAL is returns an error.
We think it may be due to the way Workbench is interpreting dates and points/commas for decimals. We have tried to change the region settings of the server but the problem persists. Any suggestion how this can be changed for Workbench?
Best Answer
-
We were able to solve the issue: we have changed the format settings in the Registry Editor by going to HKEY_USERS\.DEFAULT\Control Panel\International and there we have changed the values for the needed strings.
Notice that we needed to change in HKEY_USERS to affect all the server. When we were changing the region settings in the control panel we were changing only for the user logged in
0
Answers
-
Domo Workbench is attempting to process everything in an American way. To get around the date issue you can utilize a Custom Date Format Transform on your data where you can specify the specific date format for Domo to interpret your data.
As for the numerical column you could utilize a Search & Replace Transform to replace the commas with decimals so Domo can interpret the data properly.
It's not ideal but should get around your issues.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
We were able to solve the issue: we have changed the format settings in the Registry Editor by going to HKEY_USERS\.DEFAULT\Control Panel\International and there we have changed the values for the needed strings.
Notice that we needed to change in HKEY_USERS to affect all the server. When we were changing the region settings in the control panel we were changing only for the user logged in
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive