Ask Magic ETL questions and get answers from Domo peers
Hello, I have a python script which is part of an ETL to transform a combination of 3 input datasets. The python script contains multiple if else statements and for loops which is taking aroung 4 hours to complete the ETL pipeline. I want to know if there is an option to parallelize the python script in Magic ETL to reduce…
HI, we're migrating from username sign in, to okta that uses email as user id. we have an existing user info data with user id as username (xfsgsbss) but we would have a new data with user id as email(fdhsvbsjsbsjsh@email.com). I want to be able to join both old and new data and make sure the right attributes goes to them,…
Hello! I know variations of this question have been asked in the forums but I haven't been able to find a solution that works for me. I have a column Project Name that contains Projects out of Financial Force that may contain an At-Risk ticket number, which is formatted as: AR-00000 i.e. literally "AR-" or "AR - " followed…
Hi, I'd like to create a re-useable calc that will filter out certain words or phrases that are found in a field. example: Closed Description field might have the words or phrases below which I do not want my cards to display those records. SPAM, N/A, Dup, Duplicate Thanks, Lisa
Can you convert Magic ETL into a SQL Script?
Hello, I'm attempting to perform a correlated subquery using an inequality as shown in the below example. SELECT a."Opportunity ID", a."Owner ID", a."Created Date", a."Close Date", a."Snapshot Date", a."Last Modified Date", a."Next Step", a."Competitor", a."Amount", a."Stage", (SELECT COUNT("Opportunity ID") FROM "pushes"…
Is there a way to save data and possibly append to it? Let me give an example. When I pull data from a database, I would like to pull data and when I pull data tomorrow I want the original data to still be there. So I want to be able to see user counts by region today, and then in a month I would still like to see what it…
I have 2 contact databases where I need to join them based on both phone number, name, and email. I am able to currently join on phone but the email part I am having an issue with. When trying to join on email it isn't working. What is the best way to join on email address and if possible where emails closely match?
I'm using this formula to calculate the average quarterly engagements SUM(Total Engagements) / COUNT(DISTINCT QUARTER(Date) ) When a marketing campaign data falls under full and partial quarters, however, this approach generates a skewed number. I need a way to test for and countthe number of full quarters that a campaign…
Hi everyone, I have a dataset which looks like the following: EmailRunning Latest VersionVersionfred@email.comYes2.1bob@email.comYes2.1angela@email.comNo1.0tran@email.comNo1.5 I would like to do the following: If someone is not running the latest version (Running Latest Version = No) then send an email to the person as an…
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