Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
How do I get non-matching records from two tables in Magic ETLI have two tables A and B , a unique record is identified by an ID and a date. I am interested in … -
Assigning the same value to different days of the weekHi All, I am using the following Beast mode (Goal) to assign the same value to Monday ,tuesday, wed…
-
Extracting the Date Based on a patternHi All, I am trying to extract the date from one column based on a pattern..For example in the tabl…
-
Checking if first character is a *-Beast modeHi All, I am trying to flag the rows that have the first character starting with a *...For ex: *SLD…
-
Looking for Pattern in DataHi All, One of the fields (orderstatus) in my report has values like 37141 SLD BAM , SOLD BRANDON B…
-
Can you filter data from input dataset in a MySQL FlowHello, I have a dataset that has data for the past 20 fiscal years. I use it in a flow that only lo…
-
Writing Beast mode with Data label of MeasuresHi All, I have three measures - Open qty, onhandunits and openpoqty... When they are brought into t…
-
Group By -- all additional columnsI have a data set that looks something like this: Rep Name --- Department --- Month 1 --- Month 2…
-
Can someone help me calculate employee turnover in Domo?I'm relatively new to Domo and wanted to reach out to you about calculating Employee Turnover rate.…
-
Renaming Columns and NOT breaking cardsI am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I …
-
Combining Row DataHi everyone! I've asked this question before and was advised to use a pivot table to combine two ro…
-
Information missing after Join DataI have a report just under 3,000 rows. (Left Table) I have a master list with just over 20,000 rows…
-
PDP Settings - Is there a limit to the number of columns associated with one policy?I'm working with a weird dataset/conditions, and wanted to associate 18 different columns and their…
-
OR statements in card filteringHi folks - We have a dataset where users can have datapointA and datapointB. We want to build a car…
-
Date_Format Fiscal week number and YearHi All, I am using the Graph by capability in DOMO Visualize and I want to get a filter to display …
-
Performing Calculations on TimestampsScenario: I need to calculate how much working hours time has passed between a creation date and a …
-
Max number of columns in a dataset?Hi, What is the maximum count of columns for a dataset? Thanks!
-
How to build a sales by state US Heat Map DOMO CARD Drillable into different vendors (US MAP)Hi everyone, Just wanted to check if there is an article that will help build a sales by state he…
-
Beast Mode to remove values based on card selection?Good afternoon, Is there a Beast Mode that can be written to exclude certain values from the broad… -
Beast mode to show only one monthHave a dataset for fire drills we have several locations that run them every month i want to create…
-
How do Dataflows impact Dataset Certification?I'm exploring the option of implementing Card/Dataset Certification for our company. I need a bett…
-
Beast mode for count distinct by concatenating two columnsHi All, I am trying to do the following beast mode operation: COUNT(DISTINCT (CASE when `ord_date`…
-
Day of week Beast Mode CodeHi All, I am trying to do the following calculation in Beast mode but I am getting some errors.. Ca…
-
Syntax of ANOVAF(), ANOVAP() and TTEST()These functions are supported in the Fx Tile in Magic. Does anyone have some syntax examples ? The… -
Generate Date Range Column from Two Date ColumnsHi all ! Im trying to generate a date column with a range of dates from two columns: Table I have … -
String to DateHi I'm trying to convert a string to a date where the string shows "day Month", ie &q…
-
Domo Python errori am using the python tile in domo magic etl i am trying to cast a column to a category but when i… -
DOMO acting SLOW!!!!!!!!!!!!!!!!!!Is DOMO acting slow for anyone else? This morning, it has been crawling.... and I can barely get a…
-
Python Tile Typecasting while Reading DataA quick question in the magic ETL python Tile API method read_dataframe can you include the dtype p…
-
Deduplicating a table based on the content of certain columnsI have a dataset that has about 20 columns in it. The first column contains ID numbers and a lot of…
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