Change a number to a text
AttuAk
🟡
I have an 'ID' field that has been imported into Domo as a number but I need it to be a label or text. I can see how to go from a text to a number but how to go from a number to a text? What is the beast mode logic that will allow me to make this update?
0
Comments
-
I don't know the best/right way, but here's a workaround that I've used before. In a Bease Mode, just put the number field inside of a string function. Example: TRIM('ID')
0 -
I would suggest using Magic ETL and using the Set Column Type operator. You can then tell it that you want it to be a text field and you wouldn't have an extra field created when you create a Beast Mode Field. If you are not wanting to create an ETL, the TRIM function as stated above looks like the best option.
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
This discussion has been closed.
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有