Ask Magic ETL questions and get answers from Domo peers
I have my SQL raw dataset set to merge new rows which is working correctly: This SQL dataset is the input for my ETL attempting to process New rows then Upsert in the output dataset: However my ETL fails to run due to the stated error: Am I setting something up wrong? My raw SQL data is not partitioned but it is using the…
Hi, I'm trying to join two sets of data together (assignments submission data & assignment summary data) For the output, I am trying to get a list of all assignments with a due date in a date range that have not been submitted by the students. The assignment submission data has a row for every student that lists every…
How to build this report on domo.When i export to excel.It should exactly look same .which chart type should we use
I have a dataset that failed to run due to an error from the very beginning node. It said "Failed to convert value '5785586.012810127' from type 'String' to type 'Date'." However, that input itself runs normally and the data looks legit. I checked, no abnormal and no value of 5785586 anywhere. I tried to change all…
I was trying to use the formula DATEDIFF(month,date1,date2) to calculate the months between two dates based on the function details that shows up in Magic ETL (which I have pasted below). In the Unit form, the difference is returned in the specified units from the first argument until the second. For example, DATEDIFF(day,…
Hi, I am using the Filter Row Tile in the Magic ETL. I want to filter the Overall Credits Column and only get the maximum for each student. However, the MAX and FIXED BY don't work. How should I fix this? I also tried the Add Formula Tile and it did not work either. MAX(Overall Credits)FIXED(BY Student ID)
Hi Domo team and users, I am using an HTML table for my card, because I need to implement some cell specific conditional formatting (not shown in this screenshot) and only HTML Card works out for this. But while using this visual, there is no option to consolidate the repeating vales in a column. Any insights on this is…
I have a column Bill-To (interger) I use Python Tile to run this script to fill the nulls cell with the previous cell value #Import the domomagic package into the script from domomagic import * #read data from inputs into a data frame input1 = read_dataframe('Select Columns') #write your script here input1['Bill-To'] =…
Hi, Select Columns 2 has four columns, they are EFFDT, ACAD_PLAN, DESCR, and ACAD_CAREER. I wrote a Python script to filter the EFFDT column so that it only includes rows where the value is 'A'. However, when I try to join this dataset with another, I receive an error stating that the referenced column, which is the…
I have dataset where the values are like this. Column name item and dependent Item Dependent A x, y Here I need new dataset where values should be like this by using the magic ETL. How to do this Item Dependent A x A Y
It looks like you're new here. Sign in or register to get started.
Have a Domo product enhancement idea? Submit or upvote on ideas in the Ideas Exchange.
Ask questions about Connectors, Workbench, Cloud Amplifier and get best practices from Domo peers
Ask questions about Magic ETL, SQL DataFlows, DataFusion, Dataset Views and get best practices from Domo peers
Ask questions about Beast Mode, Cards, Charting, Dashboards, Stories, Variables and get best practices from Domo peers
Ask questions about App Framework, Workflows, Domo Bricks, Domo Developer, API and get best practices from Domo peers
Ask questions about Jupyter Workspaces, R & Python Tiles, AutoML and get best practices from Domo peers
Ask questions about Domo Everywhere, Scheduled Reports, Mobile and get best practices from Domo peers
Ask questions about Governance Administration, Approvals, Teams, Alerts, and Buzz and get best practices from Domo peers
Watch how our Customers are using Domo to solve their complex problems.
Domo support and product teams are here to live-answer questions about the most recent product releases. Please post questions in this Forum board for all users to benefit (rather than submitting a support ticket).
Questions or discussions related to Domo University, trainings and certifications