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…
