magic etl
Discussion List
-
1How do I insert a row which is the variance between two other rows?I have an ETL output table with two rows (highlighted in green) and I would like to add another row… -
Avg. Time between purchase ordersHi, Domo newbie here. I am trying to find the average time between orders. The columns I have are… -
9More Dataflow suggestion: When I "cancel" out of a data flow don't dump me back to the Dataflow pageIt doesn't always happen, but when it does, UGH. I hit cancel when in an ETL and then I go all the… -
Is there way to extract week of quarter from a date column?The default week() function extracts the week number from the start of the year and runs 1 to 53 or…Answered ✓ Siddhesh_Bandekar 30 views 2 comments 0 points Most recent by Siddhesh_Bandekar Dataflows -
Automatically update the column value by current month and year in Magic ETLhi guys, I got a table on below and some columns using month/year as column name. i would like to m… -
Limit on ranking tilesI added 20 ranking tiles to me Magic ETL, but it fails stating out of memory. I removed 4 of them, … -
Magic ETL v1 UpdateWe wanted to share a planning update and a correction to an earlier communication that was made abo… -
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 … -
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… -
Calculated Fields - Pipedrive ID'sHi, I am pulling in data from Pipedrive and need to use Calculated Fields to convert Pipedrive Fiel… -
Period over Period in a tableI'm attempting to do a Period over Period in a table, but want to keep the date range to previous w… -
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…
-
1ETL v2「行のフィルター」のNullにハマった話ETL v2へ移行注意に書いてありますが、実際Nullにハマって、v1とv2での評価の違いを確認しました。 Nullは… -
2Option to manually run Magic ETL v2 without optimizationI love that ETL v2 allows automatic query optimization because it significantly cuts down the run t… -
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… -
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… -
Pendo connection: how to add a date column to a dataset?Hello! I have created a Pendo connection to domo but a date column was not pulled over with the dat… -
Duplicate data points for Weekly Reporting. I need the most recent day for weekly reporting.Our subscription data is collected on multiple days throughout the week and creates a snapshot of t… -
Magic ETL Forecasting TileHi, I have a dataset that I have grouped together into monthly data (using the LAST_DAY function i… -
Comparing two datasets for missing sitesHi, I'm looking to compare two datasets from Smartsheet to identify which sites are missing from on…
-
Replace text and value mapper failingI have a couple data flows that use replace text or value mappers to remove certain text characters…
-
Replicating SQL statement in Magic ETL Formula toolHi All, I am trying to replicate the following SQL statement in the MagicETL formula tool.. (SELECT… -
Magic ETL formula HelpHi All, I am trying to use the following transformation for joining but I am getting an error...Can…
-
How to always correct the date to the 1st.Hello all, I want to know the code for ETL "Add Formmura" function. The column ”Data” wil… -
Group By -- all additional columnsI have a data set that looks something like this: Rep Name --- Department --- Month 1 --- Month 2…
