Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
How to input identifiers using identifiersI have a data flow that has multiple properties and competitors. I was looking for a way to label a… -
Need help mimicking recursion with partitioned datasetsI need help implementing a particular use case for partitions: importing selected partitions from a… -
GA4 campaign and session campaign data Joining questionI have a unique question… some context: I have a dataset from the Google Analytics 4 connector tha…
-
How is Timezone inherited from source then converted?I have a dataset coming in from the Gong connector and some timestamps come in as text fields (sche… -
Date format questionHello all, I have a snowflake i/p data source. One of a column is a date field and it showing up a…
-
I want to create a column that contains the total sum of another column.Hi everyone, looking to create a column that contains total revenue in order to find individual con…
-
Error Message on Run when Using 'New' Data SelectionHi all, I have an ETL with a View of a Dataflow as the input - data selection on input set to 'New…
-
Multi-tab inputHello, I have a input data set that is a multi-tab spreadsheet. I used File upload option to impor…
-
How to remove whitespace after a full name in ETLI have a name column with a full name: example Bob Dylan and am joining to another dataset by name.…
-
Can I get the MIN date over a partition with a formula tile?I need to walk a date column partitioned by the value of another column (UID) to find the earliest …
-
Preview flow "from here" option?I think I know the answer, but I thought I'd check anyway … Is there any hack to cause a Magic ETL…
-
ValueError: The truth value ...Hi Folks, I'm having an issue with a Python tile in Magic ETL , the code works on my machine (pycha…
-
New Dataflow Run OptionsLooks like Domo has silently updated trigger options for dataflows (hopefully its not silent and th… -
Data transformation ideas around old/new user dataHI, we're migrating from username sign in, to okta that uses email as user id. we have an existing …
-
Using a Power BI datasetHello, Is there any way to import a dataset created in Power BI (via Power Query) into Domo as…
-
Changing dataset update method from Replace to Partition doubles dataWe've noticed that if we change the update method of an existing dataset to Partition from replace,…
-
Issue with Sales Data Tracking and Date TransformationHello, I'm encountering an issue with tracking sales data in from our CRM. The problem arises from… -
Formulae function for table instead of line by lineI have two tables. The first table i have a list of telephone numbers. The second table, a list of …
-
Why doesn't the Date Settings feature in Magic ETL update my dates?When I navigate to Settings and change the Timezone to America/Los Angeles, it doesn't change any o… -
Data SnapshotOk so we have a dataset in one of our databases that periodically gets updated. Every so often, we… -
Adding a Python Function or Google Translation into the Magic ETLHi, I am currently pulling Datas of Twitter's feed of specific words from the twitter connector o…
-
Establishing a consistent ID using Rank and WindowHi, With using MagicETL i wanted to understand if it possible to enforce a consistent ID where on…
-
regexp_like for pulling specific value out of text stringHello I need some help pulling out T#### and some T####.### from text string. REGEXP_LIKE('text',…
-
HELP! Can not get this ETL Formula to ValidateCan not get this ETL Formula to Validate CASE WHEN HdrParentItemCode IN ('ZROUGHIN', 'ZWATER', 'ZS…
-
Fill in Blanks based on existing columnHi All, Financial Analyst trying to tackle ETLs. Vaguely familiar and can work my way through Magi…
-
Single item Filter with CONTAINS functionalityHi all I have a table of 1,000+ people. Each person = one row. One of the columns shows the comp…
-
Cleaning data off an appending datasetHi Dojo, We have several datasets that are appending a decent amount of data each day, and we do n…
-
Chose the newest date availableHi All, I am working to combine two tables. The first step I need to take is to filter the project…
-
Flag for duplicate recordI have two datasets, same structure/columns, 1 large dataset with all records and another large dat…
-
unpivoting dataI have data this way: Account | Category | Date 12 | Phone | 01/01/22 12 | TV | 01/01/22 13 | …
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 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