Ask Magic ETL questions and get answers from Domo peers
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…
Every quarter I am adding a new budget file, and when I am adding Q3, I get this error. This did not happen for Q1 and Q2. The file I am adding does not have a BATCH ID column, but I do have an email connector set up to receive a weekly file for the actual data, that does have a BATCH ID. I know this one might be hard to…
Why does the order of elements change every time we run an API or an ETL? If I put a select column tile on an ETL, immediately followed by an output, I would expect the output fields to be in the order of the select column tile. I'm currently working on a complex aging flow and running the flow makes the dataset wonky and…
Hello, Please see below on what I am trying to do. I have open orders that are ranked based on earliest ship date and the ORDQTY. I am looking at the total sales QTY for that model and trying to do a lag calculation to see if a specific line item is fulfilling the outstanding sales qty or going into a negative number which…
I'm trying to connect two datasets to track contract fills per week. The screenshot is from one of the two datasets and it includes the contracted amounts of each commodity and the Start/End dates of the contract. The second dataset has data pertaining to the amount of cases actually received per day (which I have…
Hi Community - thanks as always for the consistent great help. I'm attempting to Group/Pivot/Join/Append (not sure exactly what the methodology will be) multiple rows of Patients into single rows with additional columns. Right now, each patient event is on it's own row. So, a patient seen on Monday and then also on Tuesday…
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