Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
Converting Text column with fiscal periods to a dateHello, I have a relatively simple dataset with one column that lists fiscal periods, another with …
-
Question about using recursive reports but only reclusive until post monthI am working on setting up some recursive data structures to capture the data I need for this insta…
-
Dataflow loads in preview, but not in actual dataset?Any troubleshooting tips for us? Our data flow's outputs: Work when we run a preview When we run i…
-
json dataWe have a no SQL database, where our data is stored in Json format. Which is nested and has further…
-
List of Months between two datesHi All, I am trying to create a Magic ETL V2.0 that lists the name of the months in between a hire …
-
Removing Duplicates with ConditionHi All. My dataset have a lot of duplicate rows so I wanted to use "Remove Duplicates" in…
-
Division By Zero - Be Aware - Failed IFERROR, IFNULL, and GROUPBYWhen you're performing calculations over 100s of millions or records sometimes you come across divi…
-
Lead Function in Rank and Window Returning Self Referencing ValueFor some reason I am getting a self referencing value rather than a NULL. In this example, I was e…
-
Automatic Record Matching - CustomersHowdy! New Domo customer here - first time posting in the Dojo! We're bringing in accounts from var…
-
How to force legend to stay in a Specific orderI have two questions: 1. Is there a way to sort the legend in a specific order and have it stay th…
-
New nested statementI Need to create this nested statement in the Domo Dataflow but I keep getting a syntax error. I t…
-
Any Way to Use Regular Expressions to Change Case of Specific WordsI've got a requirement to change the appearance of articles and prepositions in words in a column t…
-
Dataset column description mass loadIs there a way to be able to edit the column description field massively. For example if I have all…
-
Is there a equivalent Excel WORKDAY function in DOMO? Or is there any workaround way?I have a start date, I want to know the next work day after a specified number of days. (exclusive …
-
Summing Values Between Dates & Comparing to Other ValuesHello, I'm looking for help with a problem I'm having comparing pay for a pay period to a providers…
-
How can I count occurrences grouped by a given field?Hello Domo users, I need to count the number of occurrences grouped by a given field. See the exam…
-
Is there a way to have a dataset sorted alphabetically?I have several datasets that have over a hundred columns... and I'd like to have them sorted in alp…
-
What is the difference between Multi cloud and federated?What is the difference between Multi cloud and federated? We use snowflake for data warehousing, t…
-
Filtering data will completely remove blank valuesHi community, I'm not sure if this is by design or if this is a bug. Filtering data within a field…
-
Domo Test and Production Instanceshi all, In the organization I am currently working in, we reached a point where we are developing a…
-
Case Statement helpI have an ETL with several joins and calculations. My final output is good except for this last pie…
-
Domo - delete dataWhy does Domo not have a simple way to delete certain rows that match a criteria? How can I delet…
-
Compare one column to another then out other data.I am not an SQL person by any means. I am using a Data set where I am comparing the supervisor's na…
-
separating Output datasets from ETLI think I made a a mistake of having 1 ETL facilitate some simple transformations for several input…
-
Fill down values in a column in DOMO ETLI am trying to fill down values in a dataset that I have via the ETL process and was wondering if t…
-
Adding 1 year to a date and returning the new yearHi, I am trying to return the year after a specific date, I tried the below but it is not returning…
-
Adding data that matches a date to a date dimension table.I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be ab…
-
Magic ETL: How to REMOVE Rows Meeting a Two-Column Criteria?As part of my ETL, I'm trying to REMOVE rows that meet the following criteria: column 1 is NOT NULL…
-
To create ETLI want to get a new etl by connecting two datasets. All stages are working, but they do not pass to…
-
Disregard - failed to convert value from string to booleanCan someone tell me why this isn't working....??? Nevermind - I figured it out.
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
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 417
- Cards 408
- Magic ETL 384
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 159
- Workbench 147
- 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 58
- PDP 55