Ask Magic ETL questions and get answers from Domo peers
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…
I have a start date and end date with a total sum of hours to work. These are each 10 days with an average of 3.2 hours and 2.8 hours respectivelivy. Is there a way i can display each indiviudual day of the date range with the work per day? Something like this?
Hi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this in the ETL. Here is my formula CASE when campaign = 'CM1' then 'Web' else channel END But this is not giving me the expected output. Could anyone please help me with this? I actually wanted to achieve this in ETL only, not in…
Hello everyone, We have three SQL formulas that have worked for the better part of a year but twice now will unexpectedly develop a calculation error without any more detail. This stop the flow in our ETL structure. We are trying to transform data in a couple of ways. Below are the three forumlas that are failing in the…
Hello All, I am attempting to append two data sources through magic ETL. They have the same columns and data type. table 1: A,B,C,D,E,F,G Table 2: A,B,C,D,E When i try to append the two tables by including shared columns, the resulting table looks like this Table 3: A,B,C The table includes the combined A,B,C columns from…
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