Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Improve Dataflow EfficiencyHello, Domosapiens, I currently have a data flow that is taking 14 min or greater to run. The desi…
-
Impact of deletion ETL, input datasetsHello, Let me send my question. Several Input datasets, ETL, one output dataset, and the cards ar…
-
Schedule report to send out to email of my co-workers.Hi, When I schedule a report to send out to my co-work from DOMO Card, there is no option for me to…
-
Invalid query check your dataset schema.I have run an ETL within Magic ETL and got error "Invalid query check your dataset schema"…
-
Rows Gone Missing in ETLI created an ETL. The final step -- where it leads to the output suddenly causes ~20K rows to go m…
-
Filtering is not supported ErrorHi, I built a Radio Button selector card as a filter for 2 other cards. The 2 other cards are b…
-
Adding an "Activity_Date" to a nightly refresh dataset.I just set up a connection for a dataset that doesn't have any fixed 'date' column. The only date c…
-
Filter by aggregate work around?Hi there, I'm aware that you cannot filter by an aggregate (even if created in breast mode). I'm wo…
-
How to Export filtered dataset?I have a 1 million row dataset in Domo. I want to filter the data, and only export that data in a C…
-
Formula to search textHi domo fam! I am currently working on two ELT formulas: the first I am trying to search a string f…
-
Summing unique values based on a separate columnHaving issue trying to sum values that have a one to many relationship without over-counting the va…
-
Extract Items from a listI have a mongodb data set that has a list of items nested within a field. I am trying to check if c…
-
How to dynamically add "missing" dataHi everyone, I have a list of equipment that I want to attach to a date column for everyday of the …
-
Error when creating a case statement for a data flow columnWhat am I doing incorrect? It gives me an error while using the case statement.
-
Week to Week Sales ComparisonI'm looking for a way to use beast mode to calculate last week's sales and compare them to this wee…
-
Rating Level to CurrencyHello, I'm having trouble creating a beastmode that would convert a rating level into a currency.…
-
1st of the month with Current Month FilterI'm trying to create a date filter that on the 1st of the month it shows previous month otherwise i…
-
MagicETL2 Filter issue?I have a filter in my dataflow: id NOT EQUAL value This filter removes all rows that have 'value', …
-
Duplicates : counting them, not removing them?Whats the best way to count duplicates in a table using ETL and or Beast mode on a card? Lets say …
-
Show Top 10 in Chart (Rank in Beast Mode)Hi, I am trying to build a multiline chart based on the following Dimension: Date (x-axis), Search …
-
What is wrong with my Pivot - Uncollapse Columns? Showing NullHey I'm trying to pivot a column, but the new columns are all null Here is the original data This i…
-
Show all dates between start and end date columns on calendar cardI have three columns; 'user name', 'start date' and 'end date' representing time off from work. I'm…
-
Joining or Appending Data HelpI have a dataset (dataset 1) with individual rows as a specific job (with an identifier key) with d…
-
Unique Values Pulling Through twiceI've used an excel upload method and I'm tidying up the dataset using Magic ETL. On one of my colum…
-
How can we use similar function as Vlookup??I would like to offer a volume discount price for each company A, B, C and calculate total biil. Th…
-
Page Analyzer Link filter not working - Deep LinkingFollowing the notes on Sample Beast Mode Calculations: Miscellaneous Transforms, the section on Cre…
-
ETLI have a column with multiple categories values, I want to convert this categories values to column…
-
Recursive Issue Help - New Magic ETL 2.0Hello Community. I am trying to follow the recursive guide here, but I am obviously missing a step…
-
Business days between date functionI use the datediff for business days function in a number of mysql data flows and it works great. H…
-
What is the point of a full join in Magic ETL?So I get Left, right, and inner joins. But, what is the point of a full join if it returns null va…
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 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
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 416
- Cards 408
- Magic ETL 384
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 159
- Workbench 147
- SQL 131
- Charting 130
- Date 126
- Analyzer 121
- Table 120
- Governance 102
- Domo Everywhere 98
- Visualization 96
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55