Ask Magic ETL questions and get answers from Domo peers
Hi, I am seeing reference to a Writeback Tile option in the Datasets section of Magic ETL in Domo documentation. I don't have this option or see refences to it anywhere else (forum etc). Anyone here know anything about it? Eg:
Hello! I am trying to edit an ETL with three input datasets.. My goal is to get the 'GLAcct' row of data from the "GLAC PARTS (EZ TEST)' input dataset into the GLBD_V2 datset. Currently, the join is taking the 'GLAcct' under the input dataset 'GLBD_v2'. The request I received was to add a column onto one of our cards…
Hello, I have a Magic ETL that provides open order data based on an item number. One issue I am facing is if I have two or more types of open orders for an item, then they will cross multiply. For reference, I have 3 open internal requisitions and 3 open sales orders for 1 item. Instead of displaying 6 rows (3 IR and 3…
Magic ETL Activity Using the DataSet in Domo you created using Workbench in the previous activity, 1. Use Magic ETL to parse the currency code from the "Transaction Amount" column and separate the amount and the currency code into separate columns. Submit: A screenshot of the output of the data showing the different…
I have a multi-tiered equation based on criteria. Initially, I have many nested Case statements, but it didn't work so I tried to simplify. I need an equation based on the job open date, the customer, the proceeds A and proceeds B. So before 10/1 we had a straight fee based on a % of the proceeds A. After 10/1, we use a %…
I have a column that is a text column has values in %, $ and -ve values as well. I tried replacing the % ,',' and '$' to have only numeric values to convert it into a float or integer column. However I am getting the below error. What can I do to convert the numbers into numeric column so that I can apply calculations to…
I am trying to convert a string column to floating decimal, but I get the below error. How can I fix?
My dataset has a Year & Month columns, I would like to add a 'Month End Date' Date column into this dataset with magic ETL. But each month has different end date so I'm not sure how to go on about this
I have a data set that brings in names under the column BDM Name with FY 2024 at the end of the name, see below screenshot. What is the best way to remove the "FY2024?" I have about 8 BDM names I need to change. Should I use a replace text tile in ETL?
Hi, I am running into a weird issue. In most cases you can use "Save As" to make adjusted copies of a card or dashboard without changing the original. However, that's not working for ETLs for me. Instead of having a separate ETL, it keeps sending me back into the original. I'm just trying to apply the same name mapping as…
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