Best Of
Re: Are "Joins" case sensitive
@MarkSnodgrass beat me to it. Had it all typed up and then had to go to a meeting and forgot to post it.
Next time @MarkSnodgrass ...
Re: Beast Mode: Extract a string from a column based on a custom character is starting from right
@GrantSmith I knew you were going to suggest regex! 😂
Re: Beast Mode: Extract a string from a column based on a custom character is starting from right
Hi @swagner
Alternatively you can utilize a regular expression in a Magic ETL Replace Text tile (not exactly what you asked for but wanted to share just in case you wanted to go this route):
^.*-([^-]+)$
This will handle any number of dashes in your string.
Copy and paste this into your Magic ETL:
{"contentType":"domo/dataflow-actions","data":[{"name":"Replace Text","id":"d7a9e1bd-ebbb-4b13-ad2b-75fd0e98fa1b","type":"ReplaceString","gui":{"x":210,"y":408},"dependsOn":["83116b2f-90d1-4b7b-ad6b-83213ce84fa4"],"removeByDefault":false,"notes":[],"fields":[{"inStreamName":"Part","useRegex":true,"replaceString":"^.*-([^-]+)$","replaceByString":"$1","wholeWord":false,"caseSensitive":false}]}]}
Re: is it possible to extract Card data through API?
Hi @colinr
Currently cards don't have a supported API to view the data from a card.
Re: What are Domo’s export capabilities?
@creed I found that exporting from Dataset is exporting all the data and ignoring the filters. I have large data with 30 millions rows. How do I break and download in easy way?
Re: What are Domo’s export capabilities?
@user00109 can you assist here on the powershell question?
Thanks!
Re: What are Domo’s export capabilities?
Any chance you can share a portion of your powershell script? I'm having an issue just getting a token using powershell and the domo api. It looks to be SSL related:
Invoke-WebRequest : The underlying connection was closed: An unexpected error occurred on a send.
jlazerus
Re: What are Domo’s export capabilities?
Are you wanting daily exports because you need to maintain a history of daily snapshots, or because you want a current version of the data available?
For my daily reports, I use the Excel Plug-In. Each morning, I open the file and it asks me if I'd like to refresh the file. I use the entire page as the area for any pivot tables, etc, and simply have to refresh those, as well.
If you are needing the history, one kind of annoying workaround would be to open the file and copy/paste contents to a new file and save it with the date. However, there may be a Macro you could write that would refresh the data and save it to a new tab with the day's date as the tab name. Not sure, though, and the file may have to be openned still.
Re: What are Domo’s export capabilities?
Please have a look at this idea, vote it up and add your comments to what you would like in this feature.
Thanks!