Best Of
Re: Data format from Jupyter to Dataset
I was having a similar issue with a date column that changed to text when I wrote the data frame to a dataset in Domo. I played with the different dtypes, and found one that did stay as a date after moving to Domo (though the timezone changed, so it ended up being a few hours different than what I had in Pandas). Domo doesn't have an int data type, so maybe try changing it to a float to see if gives you something numeric once it's in Domo?
Re: SFTP Pull Connector
I do this with code outside of Domo. I created a small visual basic executable that downloads from an sftp site, to a local file. It then copies and renames the file to something easy for me to upload into Domo using Domo Workbench. I also copy a dated version to a folder so I can keep a history.
You can also script with WinSCP. But that's probably similar to what you are doing with FileZilla.
The following is a generic version of code in case its helpful to someone -
To download an Excel file from an SFTP server using VB.NET, you can use the SSH.NET library, which provides SSH and SFTP functionality. You'll need to install the SSH.NET NuGet package to your project.
Re: Changing Labeling on X-Axis of Chart that Is Grouped by Period
That worked perfectly. Huge kudos to you and I hope you have a wonderful weekend :)
Re: Table card subtotals - allow blank labels
I would probably suggest a pipe | instead of a dash because that looks like a negative sign
Re: Adobe Analytics Legacy backfill for static start, moving end date
The connectors currently don't support functionality like this doing a historical backfill. You'd need to do it manually.
Text analysis
I have a survey where the answer to many of the questions are open-ended.
So I have hundreds of responses for each question.
I created a word cloud, to see the responses, but I want to be able to do a sentiment analysis or a word analysis.
For example, if the question is "Why do you want a career in nutrition?", there are hundreds of different answers. And very few of them have exactly answer. But there are many that include certain phrases like "helping others".
So I want to be able to see those key terms/phrases, and have them counted automatically.
How do I go about doing that?
Thanks!




