Ask Magic ETL questions and get answers from Domo peers
so I have a table that looks similar to the following below. What I want to do is to label each activity in each record for each property. Only 5 different activity types don't change, but the number of records changes, so I cant count rows.
I need help with a formula I am trying to use in my ETL to calculate how many business days there have been YTD. I was using this and it seemed to work, however, it is now returning a result of 1. Can anyone assist? (DATEDIFF(DATE(CURRENT_DATE()),DATE(CONCAT(DATE_FORMAT(CURRENT_DATE(),'%Y-%m-'),'01'))) -…
Hello, I have been searching around for a similar posting, but have not been able to find one describing the same question/issue. I would like to calculate a SUM of a column while ignoring select filters applied to the dataset. The column needs to be affected by all filters except for a couple columns that contain multiple…
Hi all, I need to split a column that contains both a client name and number into 2 separate columns. Some client names themselves contain whitespace, so I cannot split on whitespace and am looking at Regex, though it's been a while since I've used it. All the client numbers are 5 digits long, though they are randomly…
When using the the writeback option in Magic ETL Why does it duplicate the dataset . example below we now have 2 outputs identical. since Domo charge by rows this will have a negative impact on the number of rows we consume waste to be specific. why cannot the original datasource be used .
Hello, As a newbie in Domo BI, I would highly value your assistance in resolving an issue that I have been unable to solve. I want to write a formula in Magic ETL that does the same function as the one in Excel from the picture: Compate D2 and D3 and if they are the same AND M3 is blank, take the value from N2. If not,…
Hi there - I am trying to part of a value that is in a column and change it to be the full name. I keep getting syntax errors whehn going through ETL formula tiles. My formula is alot larger than this but this is an example - I have tried = instead of Llike, as well as contains, nothing seems to be working (becuase the…
Raw Data : Product Values A 23 24 25 B 45 56 76 C 34 D 55 Expected Output : Product Values A A 23 A 24 A 25 B B 45 B 56 B 76 C C 34 D D 55 Here i am trying to fill blank rows with the previous non-null value in same column and i want to accomplish above scenario in MagicETL, any help will be highly appreciated. Thanks in…
Hi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we are doing in a table is taking out extra characters from a column to create a new trade_id Here is how we are doing it. when I go to add the formula tile and copy and paste this syntax, ETL is saying it doesnt recognize the…
I've been trying to do the following but can't figure out the best way to do it. I have a table that looks basically like this: user_id|ticket_id|inquiry_type I want to filter out rows for a specific user_id when ALL of the rows for that user_id have a value of "false_inquiry" in the inquiry_type field. But if the user has…
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