Issue with Data export from domo

I am using domo SDK and trying to export data from domo.Out of all rows i could see some of the rows are. not getting. properly.Domo stores data in csv format and some of columns is having comma in between the string. Is there a way to have strings enclosed with "" to avoid getting rows break.
ex-
name,address,company
gcy,bengaluru,moto
arc,SJ,Balwin road,xgy
Here 2st record has address as "SJ,Balwin road"
Comments
-
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
We are using SDK/Java and using exportDataWithQueryToFile method. Is there a way to enclosed all columns in ". If we do this we can avoid data issues.
ex-
name,address,company
"gcy","bengaluru","moto"
"arc","SJ,Balwin road","xgy"
Pls let me know how this can be done?
0 -
1) does the CSV open properly in Excel?
2) if you took the export from Domo and re-imported it into Domo using a CSV connector, does it interpret the data properly?
If yes to both, then I imagine Domo / Support would say,"the data is parseable by standard tools," leaving the responsibility to you to reformat the data the way you want."
if both Excel and Domo fail to parse the data properly, then I would open a support ticket with Domo b/c you're right, there should be a way to escape delimiters.
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
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive