Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
How to give an indicator for a time rangeHello, Can someone give me some suggestions on how to deal with my case: I have a table with p… -
Download the Schema of a datasetIs there not a way to download just the schema of a dataset? I'm doing some documentation and it wo… -
Monthly AverageHi, I want to create a Table Chart to show the service level by month for this Fiscal Year. I've … -
Row size is wider than MySql supports. Please reduce the row size or number of columns.OK so I have this one dataflow, DataFlow A, that feeds into other dataflows, DataFlow B and DataFlo… -
Using two different datasets with ETL calculatorHi all - I am trying to convert values in a dataset using an exchange rate contained in another da…
-
PDP - Policies for Owners / Simulate PoliciesWe are utlilizing PDP on a dataset which we have duplicated the data to split it into three categor… -
lost all beastmodesChanged the owner on a card and right after that, evey beastmode disappeared. Anyone ever experien…
-
how to replace blanks with values from another columnHi All, I am trying to populate blank cell with a value from another column, i.e. if 'coun…
-
SQL/Beast Mode to extract substrings and output to multiple new columnsI have a column in my data with strings that look like this: Clusters affected:|Finance, Servic…
-
-
Help on Beast Mode Concat FormatCurrent I get for a Summary 2711 Meetings and $143043062 Total Est. Budget but I am looking for the…
-
Creation of a new variable based on delimiterHi, In my Data I have a column name 'Origin_Data' which holds data like 'aa/df', 'bb/saw', 'asd/erw…
-
how to set a MAgic ETL to only filter out past 12 months dataMy raw data contains 2.5 years worth of data and I only wanted to have the past 12 months of data f…
-
sum based on distinct in another columnhello, this seems to be straight forward, but I could not get it. I wanted to sum up the cost b…
-
Use Magic ETL to isolate the domain of an email address (company.com).I am trying to use Magic to isolate the domain of an email address [email protected] to just com…
-
Regex_replace doens´t work in MySQLHi there, I would like to adjust a column by using Regex: SELECT *,regexp_replace( …
-
Case statement using date fieldI am looking to do case statement summing a column based off the most recent date in a date column.…
-
Chrome auto fill username in DataFlow descriptionsWhen using Domo in Chrome (after a recent Chrome update), my domo username gets auto filled in the … -
Do not Generate Output Table in transformation not availableHello, I'm looking how to not Generate an Output Table in a transformation ? I did not have thi…
-
Is there a way other than SQL to cross-join two tables (Cartesian Product)?I know that I can use SQL to cross-join two tables. However, that step is only a portion of my data… -
Previous month ending balance as current Month Beginning BalanceHi I am trying to create a beastmode that takes this months balance and subtract it from last month…
-
how can I dynamically filter out one min score and one max score in a dataset per quarterbasically, its a survey dataset that have a score of 0 to 10.. every quarter, we need to exclude 1…
-
Fastest way to append? Magic seems a bit slowHello, I am appending 2 datasets that have a only a few common columns to give me and my client…
-
Show columns in rows in a tableHello, is it possible to show the columns in rows in a table card?? I have this… sales…
-
Show data from current month plus 11I have been reading the posts about filtering data by the current day/date. They haven't helped my …
-
Time taken for ETL FlowHi I have a question regarding the time taken for running an ETL flow. I have this AWS object,…
-
Beast Mode Summary Number Total Count for Data 12 months agoI am using period over period card. I would like to be able to show in the summary the total "… -
IFNULL - Replace Blank with TextI am attempting to use the IFNULL formula to say if the Data Table column "Worksite" is b… -
subtracting a negative numberCould someone tell me how to write a beast mode if subtracting a negative number ex. have a fre…
-
Data Fusion CapabilitiesHas anyone used Data Fusions extensively? I've created a data fusion that combines 4 data sets and …
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