Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Parsing Dates with Different FormatsDoes anyone have any guidance for using a formula/function in a beast mode or using the regex funct… -
how to break a week between monthsHi DOJO - Happy Weekend! Basically, we have a dataset with date columns based on the start of the …
-
Programmatic filteringWe are trying to to embed domo in our web application, Is it possible to use Programmatic filtering…
-
help needed to create weekly cohortsI'm working with a large dataset that contains time-stamped user sign up data. I'd like to use ETL …
-
ML model null values and unknown error messageWe are trying to create a machine learning workflow wherein we are trying to predict by feeding in …
-
Merging Outlook Meeting & Sales Lead DataHello there, I am trying to create a sales pipeline, and have two key datasets that I need to join …
-
Group columns without stacking dataIs there a way to group numeric columns without summing the data? I want to group five columns, but…
-
Is there a way to create a static temp table in Beast Modes?I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we …
-
Moving the position of DOMO page and subpages within the same page in DOMOHi All, Can you please let me know how to move the position of DOMO page and subpages within the sa…
-
How to skip nulls in rank and window?I have a dataflow that is joining multiple datasets with information about a set of schools - 29 el…
-
Count number of character occurrence in stringTrying to see if there is a way to achieve this. I have a column that has something like the left c…
-
Dashboards/Sub-Dashboards ManagementI built a dashboard before I realized I needed to make a bunch for the entire department, and so I … -
Drill down linking to SalesforceIs there a built-in way for us to take a user to the data that they drill down to, and in my case, …
-
Add formula syntax errorHi all, I am brand new and trying to swim in the deep end and don't have knowledge of SQL so str… -
Combining data into one pie chartI'm looking to combine data from 6 sources into one pie chart. All data will be coming from Pipedri…
-
Calendar CreationHello - Can I create a calendar table based of a start date and end date? I have the start date …
-
Find most recent transaction - Dataset ViewI have a dataset with item receipt dates by branch. I need to find the most recent receiving event… -
Calculate one value against multiple values in different columnsI'm trying to find the min. the value between column 1 and a range of numbers in different columns.…
-
Aggregation on Lag/Lead functionsI used the Lag function to operate a subtraction between data point and previous data point. Howeve…
-
Datasets join issueI'm trying to create a card that can be used to present to budget owners how much they have current…
-
What is the best way to parse URLs?I currently am bringing in data from google ads and one of the columns is `landing page url`. I am…
-
Attempting to create unique rows for each possible value in a chosen columnOur business model currently offers multiple product options. I'd like to create brand new rows for…
-
Joining 2 datasets based on between condition.Hello, I have two data sets that i would like to join based on a between condition. The "Join…
-
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…
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