Best Of
Re: Can there be multiple "THEN" statements?
@Laura_M1 Yes, you can add as many conditions as you want as long as each one is preceded by "WHEN" like this:
case when A then B when XYZ then 123 when blue then red … else 'Other' end
You can find more about Case statements in the Logical functions section of this Knowledge Base article:
Re: Removing duplicates
Using the remove duplicates tile in magic etl you can choose what fields make a row unique. So in your case you would select just ID and Name to search for the duplicates.
EDIT: I re-read your question and the above solution would not get you what you are looking for. You would need to self join the data with itself so that the data can be compared to itself row by row. This will temporarili yexplode your data but hen you can filter it down before the final output.
Re: I get an error message with the Facebook Ads Advanced connector.
UPDATE: I haven't received a response from the support team yet (after a week) but I found out that if I decrease the number of campaigns by brand and only taking one month of data, and trying several times to update the data, I can finally have information by brand, by month (it takes almost 3 or 4 times trying to update). I think that Facebook has some kind of new limit on the API because before I was able to download the whole year's information with the same connector for all the brands, campaigns, and months. A little help from DOMO could improve the experience, maybe a better way to select which campaigns to load by a filtered view.
Re: Dynamic axis/column naming
Thanks for the feedback, this is definitely something we've discussed and are looking to add in the future!
Re: Set the default value of date type Variable to current date or today's date
Thanks everyone for the feedback. This is definitely something we're discussing and are looking to add in the future. No ETA at the moment but this is on the list of features to add!
Re: Is copying action nodes from one dataset to another possible yet?
@Domomon - If you're asking about copying actions from one Magic ETL dataflow to another, yes it is possible. Just select multiple actions on your ETL canvas and choose the option for Copy to Clipboard. Then navigate to the target Magic ETL dataflow and hit your normal keyboard paste command.
I hope that helps!
zcameron
Re: Reddit Ads Connector -
a 429 error means that the connector has made too many requests in a specific amount of time and has hit the API Rate Limit (can either be x/day, x/second etc). The connector should intercept these errors and then wait the required amount of time to then resume the request without failing. This would need Domo to update the script to adequately handle the 429 errors. I'd log a support ticket.




