Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
How to add the unique numbers to every row of the output?I have dataflow which consists of ETL o/p( table 1+Table 2) as i/p in sql. and further this I need… -
How to export the data from SQL data flow ?I have created dataflow, and want to send it to another department to put their inputs, so how can …
-
Best way to return earliest of multiple date fields in Magic ETLI have a dataset that has five dates... I want to add a new column that contains the earliest of th…
-
Select rows from a datset based on DateHi, I have a dataset with one column as Date. Now I want to create an ETL process to create a n…
-
Green Transform Check Marks Gone!?!?! WHY!?Wondering why the green check marks that let you know a transform had been run have been taken away…
-
ETL Select Columns "Shortcut"Hello, I work with Datasets with high counts of columns. When I create ETL's where I have to Select…
-
Grouping Dense Rank into WeeksHello, I am trying to build a product lifecycle comparison using first invoiced date as day 1 a…
-
Identify Multiple Different Matches in Same ColumnHello, I'm looking to be able to build cards that compare different products that are tied to d…
-
How to delete blank rows in a data setI have a table which I've sorted by the count of a particular column. However, the column that is s…
-
Aggregating a column in Beast ModeIs it possible to aggregate an entire column in a beast mode calculation within analyzer? (I have f… -
Sum Column Based on Distinct values in another columnI need to sum the quantity in one column based off the unique values of another column. I cannot re…
-
Merging new and legacy datasetsHello, Experts! I am reaching out in hopes that I get some guidance on the best approach for bu… -
How to create a chart with a rolling 12 month by monthAnyone have any ideas on how to create a chart with a rolling 12 month by month. I would like to cr…
-
How to manage with BigQuery datasetHello, I have to work on BigQuery dataset and I would like to know what is the more efficient w…
-
Datediff: Total Noobie questionHello all, I am non-technical, non-SQL speaker trying to figure out DATEDIFF. My problem 1. In…
-
Beast Mode Change font sizeI am using a dynamic textbox so that I can get a year on year comparison in my card which shows a p…
-
How to delete rows from an input dataset and replace the datasetI have an input dataset, on which I want to perform an operation to highlight which records are obs…
-
Convert Hex to DecimalI have a hex data point that I need to parse and convert to numeric values. Has anyone done this a…
-
ETL so much faster than SQL at joiningNot so much a question but a statement of my experience with DOMO I am not a SQL person (if tha…
-
CountIf in BeastMode or ETL ?Good Morning Community I have a 5M+ row dataset where I need to develop a "COUNTIF" func… -
Is it possible to import Python packages outside of what's given in the ETL?I'm trying to import the lifetimes package but I guess it's not included in the default python pack…
-
Multiple filters in dataset with AND & OR conditionsNameCityTroopsSupportAXYZ10YBXYZ30NCPQR20YDPQR40NEMNO30YFMNO10NAMNO20YBPQR40NCXYZ25YDMNO35NEPQR45YF…
-
Ifnull failsI'm trying to work with Null values but not getting the result I expected. I want to display 0 when…
-
Adding percentage to total but cannot apply a 'Sub Total' in tableHi, I have added a beast mode to calculate the % of the total in the table (refer to far left colu…
-
Beast Mode not available to add to Summary NumberI have a simple question that is frustrating me. I want to create a Customized Summary Number…
-
'OR' condition possible with ETL Join function?To report on video engagement by project, I need to join Workfront project field data set with a Br…
-
Edit String in Beastmode or ETLHello friends. I have a field where there are outputs like this: "Electronics | Computers…
-
Reduce loading time of input dataset in Magic ETLI have a Magic ETL dataflow using an input dataset with 10M rows. It takes around 20 mins just to p…
-
Case Statement Question - multiple resultsI'm trying to use a quick filter to select sales people associated with specific branches. There i… -
Ignore Filter in Beast ModeI am building a report in a table in Domo. I am trying to compare a calculation result to a calcula…
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 415
- Cards 408
- Magic ETL 384
- 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
- Visualization 96
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 57
- PDP 55