MySQL Dataflow Changing Column Formats
What I am trying to do is convert a bunch of time columns in my dataset that come over as text fields into time fields so I can aggregate or sum them. I am dealing with phone data, so I would like to add the call times together.
I am fairly new with using MySQL dataflows, so any help would be appreciated. This is what I have so far (I am just showing 2 of the columns I have; TIMESTAMP & CALL TIME), but the column type still shows text when I run the SQL:
Thanks for your help!
Comments
-
Try pulling your data into a card.
Although MySQL may show the datatype as text, what really matters is how the data gets stored in Vault (Domo Data Storage layer) and then interpreted into Adrenaline (Domo Database / Visualization) layer.
If you think about it, ALL data gets converted into 'text' when it gets stored as a flat file. What matters is how the database interprets it.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
Thanks for your response and your explanation makes sense to me. This is what I did and it does not seem to be working the way I want.
I pulled the output dataset into a table card, and the new columns that I tried to convert (calltime_test, calltime_test1 & calltime_test2) are not coming over as times. They are all dimensions and not measures.
0
Categories
- 10.7K All Categories
- 1 APAC User Group
- 12 Welcome
- 36 Domo News
- 9.6K Using Domo
- 1.9K Dataflows
- 2.4K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 339 Workbench
- 252 Domo Best Practices
- 11 Domo Certification
- 461 Domo Developer
- 47 Domo Everywhere
- 101 Apps
- 705 New to Domo
- 84 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 23 お知らせ
- 63 Kowaza
- 297 仲間に相談
- 649 ひらめき共有