Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Join with Between Clause in Magic ETLI am working on converting some Redshift dataflows to Magic ETL 2.0 dataflows. I have a join statem… -
Reduce ETL Processing TimeHi Everyone. I'm looking for strategies to reduce the run time of Magic ETL 2 data flows. I'm wor… -
Division of ValuesHello Domo Ninjas - I'm trying to get a new value from a dataset, where I'm dividing 1 column by an… -
Add data to an existing Excel file in Domo?Is there a way to add monthly data to an already uploaded xls file in Domo? Rather than having to u…
-
Python TileTring to split the values in a column into multiple rows using explode and I keep getting an error.… -
beast mode for specific date rangeCASE WHEN `end_date__c` >= '1/01/2021' and `end_date__c` <= '12/31/2021' then `2021` else 0 e…
-
Creating a Link Field in DomoHi All, I was trying to have a hyperlink embedded inside a Domo Table/MegaTable and I used the…
-
Case SyntaxI am having difficulty understanding the case syntax while using magic ETL. In the current Example…
-
How to remove columns with Null values?Hi all, I have a dataset with 100+ columns. There are many columns with null values. I would like t… -
Is this a bug or user errorHi, Noticed some odd behaviour with a simple dataset I am pulling in from our db. From the column n…
-
How to represent how many tickets opened by each individual user?Hi, I am trying to figure out how to pull 2 datasets together correctly. So, one dataset is Users …
-
Only show unique values of a column in tableIs there a way, in analyzer or ETL, where we can only display one row for each unique value of a co…
-
Dashboard performance problemHi guys, I have a view that once built has 112k rows. It is built from 7 datasets. Am I right in th…
-
Why would I use a DataFusion instead of a Dataset View? Will DataFusions be deprecated?If a DataFusion has limitations on what can be edited after it's created, why would I use one inste…
-
Error filtering DataHi, I'm using a filter on a Dataset I which I need that a column A to be different to FALSE and ano…
-
Recursive ETLHi guys, I am pulling data from from our db looking like Date|Name|Value DATE and NAME is the uniqu…
-
ETL run complete, but output datasets still not reloadedI notice with an ETL I have (with a large amount of data), it takes a while for the output datasets…
-
How to Deal with Multiple Date FieldsI have a perplexing issue I'm trying to solve. I have data coming from several different data sour…
-
Trying to create a nested Case statement with multiple conditionsbasically, I need to first attest that it is in the current quarter, and then I need to look at the…
-
how to capture the current quarter using beastmodeHi Domo Masters - so, when we want to capture the current date what we do is we use>>> …
-
-
Is there a reliable way to make Magic ETL intentionally fail?I have an ETL that uses, among other inputs, a Webform that isn't always maintained perfectly. One …
-
Identifying "Last Week' when current week is 0 or 1I'm using the case statement below to identify dates from "Last Week". It works fine but…
-
Add only new recordsHello there. I have a Jira connector set up that pulls users (Name, Email, Jira ID). However, it on…
-
Period over period on one rowHi, For this particular use case I have data like below Date | Value I need to transform this to Da…
-
How to fix 'Cannot Save' error in Scheduling?I am working with the domo writeback to gsheets. It is scheduled to run each day at a specific tim…
-
single date filter for multiple columnsHello team, columns A and B are the occurrences in date format of two separate events. I have thre…
-
Freeze Header in Pivot Table (chart types)Hi Team, Do we have option to freeze header in pivottable (chart table) as i could not find in char…
-
Is there way to extract week of quarter from a date column?The default week() function extracts the week number from the start of the year and runs 1 to 53 or…
-
Automatically update the column value by current month and year in Magic ETLhi guys, I got a table on below and some columns using month/year as column name. i would like to m…
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