Ask Magic ETL questions and get answers from Domo peers
I wanted to make a quick post to let you know about an update we made to the Group By tile in Magic. In your instances, you should now see the ability to choose a new options when defining how a column should be aggregated in the Group By tile: Combine distinct strings separated by , This allows you to create an aggregate…
I have a magic etl with a Formula using REGEXP. It doesn't validate but I am wondering if I can even do what I'm doing. I want to extract all values between 2 string characters. Field Value (snip) DECODE(TRUE, IN(LTRIM(RTRIM(deposit_account_type__)),'410'),'Brokered', IN(LTRIM(RTRIM(deposit_account_type__)),'411'),'CDS…
I am working on a report where the data looks like below (sample data): Services : JAS, GAF and YAG fall under the profit center "ABC" and HIG and OPD falls under "XYZ" Date Profit Center Service 1/1/24 ABC 1/1/24 JAS 1/1/24 GAF 1/1/24 YAG 1/1/24 XYZ 1/1/24 HIG 1/1/24 OPD I want my final output to look like below, there…
Hi Team, How to compare two dates values comparison in dynamics with examples coding Thanks, Raja Parthasarathy
Good afternoon, I am trying to mark rows that match up with each other as duplicates so that I can filter them out and only have the truly unique records left. Example So after I mark and filter the only record left will be the third one that doesn't have a match. What is the best way to do this? Thank you in advance
Is there a way to take the data that has a start/stop year (Column A/B) and have it expand while retaining the associated notes from Column C? The data is in Domo, but can manipulate in excel. The goal is to convert columns A-C to E-F. Not sure which platform makes most sense to make this happen (excel, access, Domo).
Hi, I have two datasets. One has pacing data, the other has monthly data. All rows have unique IDs, however the pacing data may have either an ID from the old system (legacy ID) or the new system (new ID). Pacing: ID 1 2 3 4 11 Monthly: New ID Legacy ID 10 1 11 12 13 2 14 3 15 How would I go about joining these two…
Looking for a formula that can count the number of items in a cell, that are separated by commas and I am stumped. So in the example below, row 2 has 3 items, row 5 has 0, the other rows have XX items. Any suggestions?
Magic ETL Activity Using the DataSet in Domo you created using Workbench in the previous activity, 1. Use Magic ETL to parse the currency code from the "Transaction Amount" column and separate the amount and the currency code into separate columns. Submit: A screenshot of the output of the data showing the different…
Hello, as the title says I am trying to figure out a beast mode or add an additional column in a view/etl to flag a member when they logged in fewer times this current month compared to the previous month. I manually upload the month's numbers at the end of the month so we are measuring trends and wanting to reach out to…
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