Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Limit on ranking tilesI added 20 ranking tiles to me Magic ETL, but it fails stating out of memory. I removed 4 of them, …
-
Writeback GsheetsHello! I am new to Domo and setting up a write back to a google sheet. Ideally, I'd like it to wri…
-
Finding the sum of values based on a common column, excluding duplicatesI have a dataset with rows with IDs, start dates, end dates, and interval lengths. I want to find t…
-
Convert text to dateHi All, I am trying to convert a string to date... STR_TO_DATE(`MFGDTE`,'%Y-%m-%d') But I am gettin…
-
How to create 2 Output Dataset in DOMO (unable to load this dataset issue)Hello everyone - Good Day! I just need some inputs. I have a dataflow with 4 input dataset and 1 …
-
Quick Select Multiple Columns in "Select Column" ?I am wondering if there is a way to choose multiple columns quickly when using "Select Columns…
-
Beast Mode for Sum FunctionHi All, I am using the sum function below which is throwing an error..can you please advise.. CASE…
-
Using ETL formula for finding between datesHi, I have a dataset and every row has a date. I want to add a column using ETL that indicates what…
-
why is greater than filter not working for date.....????I am building an ETL and have noticed when I attempt to filter data by dates greater than (or great…
-
coalescing data in a tableI'm attempting to build a table, which pulls from a order history dataset and includes the followin…
-
Beast Mode to remove text after spaceHi All, I am trying to remove the text after space from the below example ..Can you please let me k…
-
Beast Mode to compare the record from the recent Monday to the last MondayHi All, I have a dataset that has the the different schedule codes by date at a PO number level..I …
-
Can I Create Variables in Beast Mode?I'm trying to create a variable that I can reference a beast mode calculation, but it keeps on tell…
-
MagicETL/SQL to join datasets using a comparison between valuesI am trying to get a geolocation based on the IPNumber. Dataset a: ipaddress ipnumber (translated…
-
IF ConditionBeast mode calculation needed.. If 'Model' value contains blank then ignore those column of data an…
-
Calculated Fields - Pipedrive ID'sHi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Fiel…
-
REGEXP_REPLACE in ETL add new line?I have data in Domo for an address that includes a new line character. This data was brought in fr…
-
Reverting Back to the old dataSet versionHi team, I changed a few things in my recursive ETL dataset and lost all the rows of data that were…
-
How do you rename null values in a date column?I have blank values in a date column which is messing with my filter, is there a way to rename thes…
-
Manually adding data to a existing DOMO datasetHi Team, I am trying to add the data to a existing DOMO dataset..Can you please let me know how I c…
-
Add Data that has been modified in the last 7 daysI have a snowflake dataset that has a modified date column. I want to merge the data that has been …
-
Setting a duplicate value in a column to null or zeroI have a dataflow where I'm joining projects to their respective tasks. Each project will have a la…
-
How to remove empty columns from a dataset?I am using a DOMO connector to import Salesforce data. The imported data has 30+ columns with no va…
-
Line over BAR chartHi All, Hope you are doing well!.. I currently have a bar chart to show the this year inventory by …
-
Problem with column sortingHi All, I am sorting a dataset in the visualizer...I am sorting by the dealer name and whether the …
-
Return data within geographical radius?I have a table containing a list of zipcodes and corresponding data. Say a salesperson unfamiliar w…
-
How can I prevent a running backlog total beastmode from hitting zero?I'm working on building a labor model for my department to track where our projected backlog will b…
-
Using UPDATE statement in RedshiftHi , I am trying to update a column in Redshift using UPDATE statement. But I am getting error If s…
-
How to find a max value from multiple aggregatesHey guys, I'm looking at our collections information from the last two years to find our best coll…
-
showing record with max dateHello I have a dataset which pulls record numbers(gn_id) and its pulling some duplicates and it loo…
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 195 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 437
- Cards 418
- Magic ETL 400
- Beast Mode 369
- Dataset 337
- Filters 184
- Card Builder 178
- API 172
- Data Flows 169
- Dashboard 167
- Workbench 150
- SQL 132
- Charting 132
- Date 127
- Analyzer 126
- Table 121
- Governance 103
- Visualization 101
- Domo Everywhere 98
- Admin 98
- Embed 73
- Pages 70
- Export 61
- Error 58
- Excel 55