Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Domo Test and Production Instanceshi all, In the organization I am currently working in, we reached a point where we are developing a…
-
Case Statement helpI have an ETL with several joins and calculations. My final output is good except for this last pie…
-
Domo - delete dataWhy does Domo not have a simple way to delete certain rows that match a criteria? How can I delet…
-
Compare one column to another then out other data.I am not an SQL person by any means. I am using a Data set where I am comparing the supervisor's na…
-
separating Output datasets from ETLI think I made a a mistake of having 1 ETL facilitate some simple transformations for several input…
-
Fill down values in a column in DOMO ETLI am trying to fill down values in a dataset that I have via the ETL process and was wondering if t…
-
Adding 1 year to a date and returning the new yearHi, I am trying to return the year after a specific date, I tried the below but it is not returning…
-
Adding data that matches a date to a date dimension table.I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be ab…
-
Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?As part of my ETL, I'm trying to REMOVE rows that meet the following criteria: column 1 is NOT NULL…
-
To create ETLI want to get a new etl by connecting two datasets. All stages are working, but they do not pass to…
-
Disregard - failed to convert value from string to booleanCan someone tell me why this isn't working....??? Nevermind - I figured it out.
-
-
String Operation Add Space to Postal CodeHi All, I cannot seem to find out how to add a space to a Postal Code Column using new Magic ETL. …
-
Timestamp Runs Recursive Dataflow Magic 2.0Hello all! I feel like I have lost it but I am looking for a simple way to timestamp each run in a …
-
Reg Ex difficultyI am attempting to pull out a string using Reg ex. I want to get the card name, so text after the …
-
Remove text from a columnHi all, I'm trying to figure out the easiest way to create a new column with slightly filtered stri…
-
How to correctly use distinct count and case when in etl (unknown error)Could someone help and explain what's causing this error? And how to correct it? Thank you
-
Window function - unique rankingHi all, I'm trying to create the following logic for column '?' based on the header column: context…
-
Converting string to dateHi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not worki…
-
Magic ETL Forecasting TileHi, I have a dataset that I have grouped together into monthly data (using the LAST_DAY function i…
-
New Year Filtering Issues by Week / MonthMy date filters are on the struggle bus in the new year y'all. CASE when WEEK(`Week Date`) = Week(C…
-
Best approach to map day of date in bulkWe need to map the Date field so that every date value is the first of the month. The value mapper…
-
How do I filter duplicative entries when two date fields are involved? (entry & modified dates)Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows ac…
-
Calculate Previous Quarter Start and End DateHello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter …
-
Format Integer or Text String as DateHello, I am using HubSpot Connector to create contact reports in Domo. A custom HubSpot Date prope…
-
Group by changing columns data type?I have daily per-item data. I am creating a new View so that it is grouped by month. When I select …
-
MoM, YoY, YTD on same store growth for different upload datesHey Everyone - Looking for help on how to compare same store growth on a MoM, YoY, and YTD when co…
-
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of …
-
Magic ETL | Remove Duplicates Old RawHi, Assume my data like that I want to become If I use Remove Duplicates in ETL, it only keep the o…
-
Removing Duplication and Ordering Objects within a Concatonated FieldHello, Our company offers several different product lines and I am attempting to count how many tim…
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 437
- Cards 418
- Magic ETL 400
- Beast Mode 369
- Dataset 337
- Filters 184
- Card Builder 178
- API 172
- Data Flows 169
- Dashboard 167
- Workbench 150
- SQL 132
- Charting 132
- Date 127
- Analyzer 126
- Table 121
- Governance 103
- Visualization 101
- Domo Everywhere 98
- Admin 98
- Embed 73
- Pages 70
- Export 61
- Error 58
- Excel 55