Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Does datafusion count against warehouse row countReading the documentation for datafusions: DataFusion: Advantages and Disadvantages * Because a D…
-
Beast Mode validated but not workingMy Beast Mode shows it is validated, but then the numbers will not display on my graph. The error …
-
Filter Field with LIKE based on another FieldHi all! Hopefully someone is able to understand what I'm trying to achieve and help with a solutio…
-
Multiple Case StatementsHi Everyone, I am having a bit of trouble stringing together multiple case statements... Th…
-
How do you change the order date "2020-01-06T16:56:00" to the first day of the month?How do you change the order date "2020-01-06T16:56:00" to the first day of the month? Via…
-
Grouping into one RowI want to be able to group the parent_wID field so that it is one row per entry. As you can see, th…
-
Trying to filter records, but something is going wrongHi there, I have a single dataset. I am trying to filter records based on 3 criteria. For examp…
-
Issue with Nested Case StatementsI have a dataset of call records. I am attempting to filter out records that fall outside of busine…
-
Whoops! Something went wrong.I have a dataflow with 50+ transforms that has been working. Recently I added some more transforms…
-
how do I convert data time field to yyyy-mm-ddThh:mm:ssso that when i export the file shows 2020-09-14T11:56:43 instead of 14-Sep-20 11:56:43 ?
-
Year over Year totals by month and sortI am trying to create a bar chart that contains totals for 2 types of requests and their lines of …
-
How do I find records created within the last one hourI have a data set with a Created Date field and I want to get data created in the last hour. What f…
-
[Beastmode] Like binary - to find uppercase textWhen I use the following (example) query it's working fine: (case when `Product` like '%PROduct1%'…
-
Case when.. multiple parametersI would like to make a beastmode for a column that contains integers, as well as null values instea…
-
How to find first non-zero number in TEXT data type in DoMo ETL (Not Beast Mode)Hi, I have a business requirement where i need to find first non-zero number in a TEXT column …
-
Why is the Group By tile in an ETL giving me an error message?I am trying to collapse my data set into a single row for each date, publication and product and ge…
-
Percentage Summary Number using Beast ModeI have a graph that displays my company's net income vs. our budget. In order to calculate the net…
-
Over Partition Clause in Magic ETL, or SQL transformI'm looking for a solution to create a new column that will either copy a shipping timestamp on all…
-
Magic ETL trigger timing - input datasets of varied sizeI think I just discovered that if a magic ETL is configured to run "only when datasets are upd…
-
Keep first occurrence of value and set subsequent values to 0I'm working with invoice data that has multiple line items for each invoice. The issue is that the …
-
Is it posssibe to create a static dataset from 7 input datasets.Is it posssibe to create a static dataset from 7 input datasets. because i want to delete these 7 i…
-
Calculating total against subtotalHi, I have a data set as follows: IDNameCondition1Condition2Condition3Condition4123ABC1101245XYZ1…
-
Using case statement to create measure net incomeI have the following case statement to categorize my quickbooks transactions into their correct cat…
-
Before & After Training on scale of -6wks to 6wksI am trying to graph out a call center metric for students 6wks prior to training and 6wks after th…
-
grouped bar from extracted textAll, I Have data in a column that looks like this: California, Nevada Nevada New Mexico Colora…
-
Recursive ETL issue - JOINHello, I am having trouble with a recursive ETL. When I update my data set "Record Status&quo…
-
Partition in BeastmodeI'm hoping someone may be able to help me understand what I am doing wrong with my beastmode logic,…
-
Aggregating 10 years of data to display by day-of-month AND month (combining all years for each day)Well hello there fellow domo dojonians, i'm hoping someone can help. This may turn out to be super …
-
Removed String CharactersHi Anyone know how to Remove Texts Before Or After A Specific Character in an ETL? For Example…
-
Combining independent Date & Hour fields into a unified Date:Hour field (in "Date" format")I have separate Date (ex: 8/26/2020) and Hour (ex:
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 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