magic etl
Discussion List
-
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…
-
Renaming Columns and NOT breaking cardsI am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I …
-
Domo Python errori am using the python tile in domo magic etl i am trying to cast a column to a category but when i…
-
Python Tile Typecasting while Reading DataA quick question in the magic ETL python Tile API method read_dataframe can you include the dtype p…
-
Formula cannot be addedHello, I am a a beginner user on Domo (used before on Alteryx). I have tired to add formula the th…
-
Help with Magic ETL to find the status of SKU items manufacturedI have a delay table (as below) where a SKU is identified by the combination of mmodel and srno and…
-
Historic Timesheet AnalysisI'm working on an analysis of our historic timesheet data and trying to calculate our employee util…
-
3Links to Input/Output Datasets in Magic ETL EditorOftentimes I find myself having to open a new tab to navigate to the various input and output datas…
-
Help with Magic ETL to calculate the distinct count of pickup numbers by plantHi All, I am trying to get the distinct count of pickup numbers by plant and pickupmonth year..Plea…
-
Forecast monthly expenseI'm trying to create a formula within ETL that will help budget owners understand how their expense…
-
Moving one column under anotherI have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corres…
-
Magic ETL - Group By Tile - Sum Multiple Integer ColumnsHi all, I have a Magic ETL flow going currently where I have three input datasets that I am appendi…
-
Calculating the count of entries not present in the future date in comparison to the previous dateHi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entri…
-
ETL or beast mode for Dynamic assignment of month based on current dateHi All, Hope you are doing well..I am trying to convert a plan table as below into the table below …
-
Looking up values from secondary data source but for multiple columns in primary data sourceSo I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I ha…
-
Checking the existence of an entry in the immediate future date and counting in future dateHi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entri…
-
column referenced isn't found but exists in the connectorIn ETL formula tab I am trying to rewrite a column name and am getting an error that says the colum…