magic etl
Discussion List
-
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…
-
Comparison of data to the immediate previous date for every consecutive dateHi All, Hope you are doing well!..I am trying to build a Magic ETL workflow to calculate the number…
-
Filter a DataSet with values from a Google Sheet?Hello, I have a dataset that I would like to be able to dynamically filter based on values in a Goo…
-
Datasets join issueI'm trying to create a card that can be used to present to budget owners how much they have current…
-
Adding Space to Postal Code TEXT String in Magic ETLHi, I might be missing something but looking for some help to add a space to a postal code text st…
-
Adding business days to a date via MagicETLHi, I'm currently calculating a deadline using a dynamic formula in MagicETL. It looks like this: C…
-
Creating buckets for unique ids to fall into, based on the sum of donations of those unique idsCapturing donor frequency: We want to count the number of donations a donor has given per procedure…
-
Magic ETL Formula Editor Tile - Minor glitchI am just wondering if anyone else has been experiencing this. I couldn't find any related posts. …
-
Calculate time between two dates during business hours, excluding holidays & Sat/SunNeed to calculate the elapsed time/minutes between Start Date and End Date, using business hours of…
-
Creating complex ranking using certain values within a dimensionHello all! I am attempting to create a sankey diagram that shows a customers activities leading up …
-
Table vs SQL Data Flows and which functions does Domo not recognize? (I'm confused)Hi, My CSM informed us that window functions are enabled. I would like to write the following via E…