Best Of
Re: writing to datasets
Thanks for the information @jaeW_at_Onyx I'll have to play around more with the syncing in custom apps.
Re: writing to datasets
Correct you can only write to an existing dataset in AppDB not in Domo proper
Re: writing to datasets
Hi @the_tree
What specific issues are you running into? What are the error messages you're getting? Are you trying to write to a new dataset? Has the dataset been correctly defined in your manifest file?
Re: REPOST: Dojo Forum for Beta Testing
Hi @Sam1
There actually is a forum for beta features - https://dojo.domo.com/categories/beta-group. You may not have access and might want to reach out to @chucki
Re: Error joining data. The left input cannot include over 10,000 duplicates.
Hello All,
I wanted to provide a little insight into why Domo will give you an error when your Left table contains many duplicates.
ETL is a very easy-to-use tool and makes doing joins very simple. We found that many people were making large cartesian joins because of how quick and easy it was to use.
Because a left join is the most common we included this error message to help people realize that they might be creating a large cartesian join. This way you do not duplicate your data on accident.
As mentioned in the thread the fix for this is to swap the order of your inputs and change the join from a Left to a Right.
Cheers!
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}]}]}

