Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Help with the SUM function, I get "An issue has occurred during processing"I am going to try to explain myself better, what I am trying to do is identify how many times a per… -
Help with the SUM function, I get "An issue has occurred during processing"An issue has occurred during processing. We are unable to complete the request at this time. when …
-
Thousands Separator in Beast ModeHi Everyone, I'd love to add a thousands separator to the formulas below. I searched and tried …
-
Average Time between OrdersStuck doing this in Magic ETL: Trying to calculate the average time between orders. For each recor…
-
Creating a rolling standard deviation within magic ETLI'd like to create rolling standard deviation within Magic ETL that uses the previous 90 rows (or p…
-
Transforming Support Staff Name ColumnHello, ETL question. For context, I am creating a dashboard for self-service reports on customer s… -
datediff at row levelsHello, I'm doing analysis of our repetitive customers. I want to create a calculation that will sh…
-
Joining 3 different datasets to match zip codesHi, I have 3 datasets each with a column containing zip codes. I want to use ETL to create a new da…
-
failed to convert value from string to booleanCan someone suggest why ETL Formul doesn't working ?? I try to get dynamic current quarter data fi…
-
How do I create a calculated column based off information from another dataset?I have two datasets: 1- contains the rep name and the number of sales they closed for each date. 2…
-
Distinct List_AggHi Folks, In Magic ETL, I'm grouping by a key and defining a new column using the formula: List_A…
-
Please help me write this filter formula:How can I write a filter formula where I want to exclude everything that says 'INTERCOMPANY' from '…
-
Time to Number valueI have tried to find a few answers on this but nothing has come up - is there a way to take a time …
-
Partition BY, filling missing valuesHello, I have sales data and want to do some calculations on reference quote numbers assigned to…
-
Condition Statement needed for ETL magicCase or if Then fomula is needed Example Column 1 have list of Contact ID's Colum 2-First/Last N…
-
Question of how to mark or pass data for certain amount of recordsso I have a table that looks similar to the following below. What I want to do is to label each a…
-
Calculate the number of Business Days in the current calendar yearI need help with a formula I am trying to use in my ETL to calculate how many business days there h…
-
Ignore some filters (not all) in Beast Mode aggregationHello, I have been searching around for a similar posting, but have not been able to find one descr…
-
Split columns based on number of characters using regexHi all, I need to split a column that contains both a client name and number into 2 separate colum…
-
WriteBack duplicating datasetsWhen using the the writeback option in Magic ETL Why does it duplicate the dataset . example belo… -
Formula in Magic ETLHello, As a newbie in Domo BI, I would highly value your assistance in resolving an issue that I h… -
Creating a separate column using magic ETLHi there - I am trying to part of a value that is in a column and change it to be the full name. I …
-
Filling Blank rows with previous non-null value from the same columnRaw Data : Product V…
-
SQL in ETLHi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we… -
Filtering Records Based on Aggregate CriteriaI've been trying to do the following but can't figure out the best way to do it. I have a table tha…
-
Can you turn a date range into each individual date in the range?I have a start date and end date with a total sum of hours to work. These are each 10 days with a…
-
I wanted to rename few items in a column based on this campaign, in the ETLHi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this i…
-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate …
-
Calculation Error : Domo is having trouble validating this formulaHello everyone, We have three SQL formulas that have worked for the better part of a year but twic…
-
append rows in magic etl not workingHello All, I am attempting to append two data sources through magic ETL. They have the same columns…
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 462 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 427
- Cards 415
- Magic ETL 389
- Beast Mode 368
- Dataset 333
- Filters 183
- Card Builder 177
- API 172
- Dashboard 165
- Data Flows 162
- Workbench 149
- SQL 132
- Charting 132
- Date 126
- Analyzer 124
- Table 120
- Governance 103
- Visualization 100
- Domo Everywhere 98
- Admin 96
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55