Ask Magic ETL questions and get answers from Domo peers
Hello I need some help pulling out T#### and some T####.### from text string. REGEXP_LIKE('text','/T[0-9]+.?[0-9]+/g', 'n') I am trying to pull the T# out of the following text string and place them in a different column. Data Exfiltration via DNS|T1048.003|T1071.004|T1572 I have multiple rows with different T#'s…
Can not get this ETL Formula to Validate CASE WHEN HdrParentItemCode IN ('ZROUGHIN', 'ZWATER', 'ZSEWER', 'ZROCK', 'ZVANGUARD') THEN 'Rough-IN' ELSE CASE WHEN HdrParentItemCode IN ('ZTOPOUT', 'ZGAS') THEN 'Topout' ELSE CASE WHEN HdrParentItemCode IN ('ZTRIM','ZDROPIN') THEN 'Trim' ELSE CASE WHEN HdrParentItemCode IN…
Hi All, Financial Analyst trying to tackle ETLs. Vaguely familiar and can work my way through MagicETL but am stumped on this one. Hoping for some help. I have a data set replicated below. I want to fill the the [BLANK] using an ETL so on the data set where the store numbers are the same and the ticketIDs are the same, the…
Hi all I have a table of 1,000+ people. Each person = one row. One of the columns shows the companies they have worked for in the past (e.g. 'BT, Shell, Facebook'.) You know what's coming…. I would like to be able to give my dashboard a filter that shows each company once and brings back any person/row that CONTAINS that…
Hi Dojo, We have several datasets that are appending a decent amount of data each day, and we do not have a need to keep data from as far back as our datasets are holding. Does anyone know of a solution that makes connectors work with a "moving window" to only hold relevant data? ETL solutions work well for our datasets…
Hi All, I am working to combine two tables. The first step I need to take is to filter the project_number by with the newest report date available. The example below shows two different project numbers The first one has the last report date as Q3 2022 - we need to capture that input The second project_number has q4 of 2022…
I have two datasets, same structure/columns, 1 large dataset with all records and another large dataset with suspected duplicate customers removed. I want to join these together and create a flag for the suspected duplicate records. I tried to add a formula tile to each dataset, Duplicate = Yes ( for dataset filtered dupes…
I have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | Phone | 01/02/22 12 | TV | 01/01/22 I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way: Account | Category | Date 12 | Phone, TV | 01/01/22 13 | Phone | 01/02/22…
Hello, I am using Magic ETL and trying to convert a text field to a date field. Earlier on my data flow I had to alter some columns by using the cast function. I was able to continue with the data flow and have the output I want. It was until I was creating a card that I noticed the "Date" is "Text". (I have some formulas…
Why does this error occur? Normally it isn't that big of a deal, but I just spent the last 10 mins creating color rules and now I am going to lose all of them and have to start all over…
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