How do I prevent a column of Team Member ID numbers being converted to "Numbers" instead of Text?
I have a column of Team Member ID numbers that i want to keep as text and not numbers. For example TMID#123456. Every time i try to upload the excel sheet, Domo converts that column to numbers (123,456) instead of keeping it as text (123456). Am i missing something? I have the column set as a text column in excel and when i preview the file during the initial upload, it shows as text. But once i complete the upload and veiw the data table, the column is saved as a number column. I'm new to Databases and excel data files. Please help and share your advice.
Comments
-
Hi,
Are you uploading via a connector or WorkBench?
Via connector there are multiple ways you can go:
First, use a dummy row with a text value like 'ABC' in excel to force DOMO to recognize the column as Text (Would have to filter it out on the cards or a dataflow, or better yet give this row irrelevant values for your data if possible)
Another way would be to use a simple MySql DataFlow and convert the Field in with a query like :
Select Concat(TeamMemberID_Field,'') AS TeamMemberID, Field1,Field2,Field3,.... From YourDataSetName
Finally, you could transform the column at card level using the following BeastMode:
Concat(TeamMemberID_Field,'')
If you are uploading with WorkBench, you should be able to access the Schema separator for the upload job and configure the field accordingly.
Hope this helps. Don't hesitate to ask if you need more help on this.
Ricardo Granada
**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
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive