Ask Magic ETL questions and get answers from Domo peers
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…
Hello, Regex question here.. I am attempting to extract names from a string similiar to this but haven't had any luck: Submitter: ["Joe Smith ","Jill Smith"] I would like to retain the commas between names so that I can split these values to different columns afterwards, like this: Desired Result: Joe Smith, Jill Smith Any…
I am trying to create a pass/fail test in magic ETL. There are four test it needs to go through to pass or fail. Once a row is listed as fail I would want all the rows matching that submission ID to fail as well how would I go about this or what is the correct formula to use? for example It failed the first test but passed…
Im having some issues with my dataflow,i cant edit the ETL beside im the owner, i dont now what i have to do to solve the issue
Hii Team, I have a dataset which is a join of a user name and phone number and their transactions ID however I need to remove duplicate transaction ID without removing the blank cells as if the user has no transaction ID against it. That means that user has not conducted any transactions. Eg: Dataset Sr No Name Transaction…
Hello, I have a relatively simple dataset with one column that lists fiscal periods, another with some product types, and another with sums of those product types. I'd like to use this data to create a bar variance card, but Domo is currently looking at my fiscal periods column like they're 'text' instead of 'dates.' The…
I am working on setting up some recursive data structures to capture the data I need for this instance it charges in a period. We can call this resident's charges. Charges are accumulated until a post date which is most of the time the 21's day of the month with some exceptions. I have a small web form that lists these…
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 DomoAI and get answers 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