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
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
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 543 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 344 Distribute
- 86 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive