Domo converts text to date
I am using salesforce data set to bring data from Salesforce to Domo. I have a text column from Salesforce. The column has value as "2016-03". I want to this to be text, but Domo transform it to a date, 2016-03-01. How can I make Domo to treat it as text intead of date?
Comments
-
You can use the Magic ETL Dataflow tool to change the column type in your dataset to text. You can access this tool by navigating to Data Center > Dataflows > New Dataflow. Under the Edit Columns section, use the Set Column Type feature.
Thank you,
Andrew N.0 -
Hi ,
Β
the suggestion of doing it through a magic ETL will create an extra dataset. So, keep in mind if is it really worthed doing it that way creating an extra dataset just to modify one column ?
Β
another simple solution would be to do it through a beastmdoe where you can say
Β
YearMonth:
concat(Year(`DateColumn`),'-',Month(`DateColumn`))
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thanks, everyone. The replies are really helpful. I think using beast mode is a better approach.
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K ζ₯ζ¬ζ―ι¨
- 4 ιε ΄-ζ₯ζ¬ζ―ι¨γΈγγγγ
- 27 γη₯γγ
- 64 Kowaza
- 299 δ»²ιγ«ηΈθ«
- 654 γ²γγγε ±ζ