Ask Magic ETL questions and get answers from Domo peers
Hello - does anyone know how to write an ETL formula to extract the numeric ID at the end of this campaign name: Display_Retargeting Package_07/09/24-12/31/24_BA:4114356 so that I can get a new column with just the campaign ID (numeric string at the end of the campaign name 4114356? Thank you so so much for any help!
We are working on building out our backend in DOMO and are trying to build a relational database instead of having individual queries for everything. We are connected to NetSuite through Analytics Connect. The raw table we are bringing in has columns for employee, service tech, service manager, etc. In NetSuite, these all…
Hi all, I am working in magic ETL and I have a dataset that gets appended each month. Most of the data is useless for what I am trying to use, except for the latest month's set of data. Is there a tile in Magic ETL that lets me filter out by latest date? I believe I could use a rank and order but am trying to not use…
I have web app that will not share data. No APIs, not even export capabilities. I could use some help with ideas of how to make this work. Here is what the website looks like on the website: And Attached is an excel file where I highlighted and copied the data into an excel sheet in three different way (Paste, Paste…
Hello, I have a dataset that has data for the past 20 fiscal years. I use it in a flow that only looks at the last two fiscal years and when the flow runs it takes a good 10-20 minutes just to read the data in the dataset and then start transforming it. I was thinking of expediting the loading process by pre-filtering the…
How can I use Magic ETL to convert a table from to without using scripting? I have to remove all scripting tiles from my ETLs. I'm assuming some combination of RANK & WINDOW, PIVOT and GROUP BY, but am running out of talent.
I have three column, first one is how many we gained this year, second one is how many we lost this year, and last column is total. I applied a filter, filter through this year the problem is I want total column go beyond this year, in another word, the filter won't affect it. Can I do this in beast mode, I try create a…
Hello, hope someone can help me. ========= I have a card level beast mode and filter: Company Name NOT IN "AAA" Destination - AAA Filter NOT IN "Exclude" =========Here's the beast mode for Destination - AAA Filter:CASE WHEN Destination like '%AAA%' THEN 'include' WHEN Destination like '%Tipp City%' THEN 'include' WHEN…
Hi, Can someone explain this to me? I have a column that have some values that contain '$' making it a string. I am running it through an etl and using str to digit while also trying to keep it a floating point value. My formula is LONG(STR_DIGITS(TRL_MISC3)) However its taking some values like this and outputting them…
I'd like to combine 3 type of reports, that is report A, B and C. All of them are daily updated report by the logistics supplier and send to my email as attachments. at the end of month, I will get 30 emails for report A, 30 reports for report B, 30 reports for report C. I use google script to automatically save the daily…
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications