Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Looking up values from secondary data source but for multiple columns in primary data sourceSo I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I ha… -
How can i write this sql statement in domo?where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '202…
-
Variable Dates (User Defined) and Status DeterminationHello there. Hoping to find a solution to an issue I am trying to solve. Summary I have a series of…
-
Can Magic ETL calculate a sum over an entire column?I hope I am missing something here. I want to simply run the equivalent of SELECT SUM(columnA) from…
-
ZIP code leading zeros being removed in datasetI have a dataset and one of the columns is ZIP codes. The leading zeros are being removed when uplo…
-
Is it possible to use a Domo card as an input for an ETLHi, I would like to create an ETL using a Domo Card as an input dataset. Is there any way to do it?…
-
Null valueVery basic question here, trying to create a calculated column returning "TRUE" if anothe…
-
Checking the existence of an entry in the immediate future date and counting in future dateHi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entri…
-
column referenced isn't found but exists in the connectorIn ETL formula tab I am trying to rewrite a column name and am getting an error that says the colum…
-
Comparison of data to the immediate previous date for every consecutive dateHi All, Hope you are doing well!..I am trying to build a Magic ETL workflow to calculate the number…
-
Reusable dataflows / ETLsWe're trying to come up with a good strategy for dealing with large datasets that contain mostly hi… -
Create a URL with CONCAT and variable in the middle.CONCAT("https://b2b.officedepot.com/rest/ODServices/api/product/priceAvailability/xml?zipcode=…
-
Is AS valid in Beast mode?Good afternoon, Can AS be used in Beast Modes to create aliases? It doesn't seem like it but I migh… -
Beastmode. How to create a CONCAT URL with several variables?Want to build the following link on a card =CONCATENATE("https://b2b.officedepot.com/rest/ODS…
-
Rolling Average for Each CategoryI have a dataset containing total monthly units by month and by person. I'd like to calculate the …
-
Calculating existing delays , Off delays and new delays on manufacturing dataHi All , I am new to Domo and I am trying to create a beast mode for the following type of data...…
-
Can I make a "mother row" to assign values from?We are a music library company, and as such a large amount of our income comes in as small royalty …
-
Replace Text Regex - IP Address RegexI need some help. I'm trying to find an IP address in a text string and pull the IP value out. I …
-
Rolling Average CalculationI have a set of monthly data and would like to calculate a 3-month rolling average. For example: J…
-
How to set the time for hourly data refresh?I have a dataset that refreshes every hour. However, it seems to follow the time when I initially c…
-
Right way to utilize string operation on long date.I have a long date that I have converted to a text. Now I want to use the string operations tile to… -
Filter a DataSet with values from a Google Sheet?Hello, I have a dataset that I would like to be able to dynamically filter based on values in a Goo…
-
Domo not capturing all data despite data range being correctHey - Appreciate your help. I have a spreadsheet that is about 380 rows long The first 370 rows ar…
-
Right way to utilize string operation on long date.I have a long date that I have converted to a text. Now I want to use the string operations tile to…
-
Best Practice: ETLs Vs SQL ETLsWe are trying to rebuild a tool Domo Tech built for us called Domo Stacker. Its main purpose is to … -
Adding Space to Postal Code TEXT String in Magic ETLHi, I might be missing something but looking for some help to add a space to a postal code text st…
-
Adding business days to a date via MagicETLHi, I'm currently calculating a deadline using a dynamic formula in MagicETL. It looks like this: C…
-
Creating buckets for unique ids to fall into, based on the sum of donations of those unique idsCapturing donor frequency: We want to count the number of donations a donor has given per procedure…
-
ETL Formula to Change a column of city, state, zipcode to Just portray StateI am trying to write a formula in ETL to change a column the has for example "Los Angeles, CA…
-
Forecast based on last monthHi, I'm working on ETL created by someone else connecting 9 data sets. This is for a forecast, the …
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 413
- Cards 408
- Magic ETL 383
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 158
- Workbench 146
- SQL 131
- Charting 130
- Date 126
- Analyzer 121
- Table 120
- Governance 102
- Domo Everywhere 98
- Admin 95
- Visualization 93
- Embed 72
- Pages 68
- Export 61
- Error 57
- PDP 55