Magic ETL
Discussion List
-
Using partitioning in ETL or WorkbenchGood afternoon. Typically, to not do full replaces of data pulls into Domo from our databases, we …
-
R and Python for determing dataframe equality in ETLGreetings Domo Community, I have currently been refactoring Magic ETL tiles and have been attemptin…
-
What are the est practices to maximize speed and minimize data storage when updating a large datasetWhat are the est practices to maximize speed and minimize data storage when updating a large datase…
-
SQL in ETLHi All, I'm currently trying to recreate a MySQL flow in Domo to ETL. One of the first things we…
-
Filtering Records Based on Aggregate CriteriaI've been trying to do the following but can't figure out the best way to do it. I have a table tha…
-
I wanted to rename few items in a column based on this campaign, in the ETLHi, I wanted to rename App to Web for this campaign, and I tried using a formula to achieve this i…
-
ETL error: "failed to convert value 'Infinity' from type 'Floating Decimal' to type 'Fixed Decimal'"Hi, I have a magic ETL dataflow. It has 2 input sources. There's a formula tile where we calculate …
-
First Non-Null Value from Column in Formula TileGreetings DOMO, Does anyone know how to find the first non-null value of a column in a formula tile…
-
4ETLでのデータプレビュー時に ソート・フィルタができるようにして欲しいETL構築後にJoinのキーカラムにnullや意図と異なるレコードを発見して、ETLに戻って修正……というケースが…
-
Creating a Pass/Fail Test in Magic ETLI am trying to create a pass/fail test in magic ETL. There are four test it needs to go through t…
-
Cant edit the ETL, beside I'm the ownerIm having some issues with my dataflow,i cant edit the ETL beside im the owner, i dont now what i h…
-
5Allow Window Functions in MagicETL Formula TileIt would be helpful to be able to write MagicETL formulas using window functions, similar to in bea…
-
Success Rate %To work out the success rate I need to (a) count number of rows where 'Status' column has 'Applicat…
-
Form Builder and Form Viewer TransformationI am trying to use submissions we get from forms in DOMO via form viewer/builder apps and turn them…
-
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…
-
Daily Dataset Update via Python fails on first run each dayI am using the Domo Dimensions Calendar as an input to a Python script that updates an dataset of t…
-
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…
-
How do i fill in the date gaps?I have a start date and an end date. How do i have those dates in between appear? (ETLs/Codes)
-
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…
-
Is there a way to track Data completeness of all field against a single column?Hi all, From a data quality perspective, I want to analyse the differences in process across teams …
-
String to dateHi, I'm trying to take the 'DUE DATE' column below (covered by the mouse) and turn those numbers in…
-
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…
-
Correlation analysis in Domo?Is it possible to conduct a correlation analysis in Domo using ETL (or other means)? If so, how? P…
-
Splitting up multiple-value fields into multiple rowsHello, I have a dataset like this: ID Num 1 10 2 20, 30 3 40, 50, 60 I want to use M…
-
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…
-
Regex Replace IssueHello, I'm trying to do a regex replace to grab a combination of letters and digits but throw out t…