Ask Magic ETL questions and get answers from Domo peers
Hey guys, Hope you all are doing well. I have an issue with data transformation in the ETL. It is best described on the screenshot below. I have multiple entries for duplicate IDs (one row for each product) and want to mark all entries for a given ID that contain Product 'c' as 1. That's the formula I used below to…
I have an app created in the domo. I also have a Group created by my Org. I want to share the app to the group, but i am unable to search the group name. Is it possible to share the app to a group ?
I need a formula for taking just the month name from this format - Thu, 29 Feb 2024 11:59 PM. I need it in a date formatted column though. I can take the Month Name using MONTHNAME('my date column') but i cant get the column to be date. Its always text. Any advice? Thanks
Hello, Domo Community! I'm in the process of delegating dataset management tasks and need clarity on permission levels. Specifically, I want to understand the minimum role level required for a user to access the history of a dataset and use the "revert to this point" feature. I've developed some reports and plan to allow…
I am trying to find a way to extract phone numbers from a text column. Each phone number is in a simple XXXXXXXXXX format, but each line can contain up to four phone numbers (ex. 4381258956 NA, 9378123287 NIS). I am able to use regexp_replace to extract one phone number, but I am wondering if there is a clean way to pull…
Good day, I want to create a beast mode statement that gives me a list of all the clients who have requested more than two devices each month. The final outcome would look like this: Request Date Individual_ID # of Requests 2024-Jan 12345 2 56789 3 11234 4 56789 2 2024-Feb 12345 5 56789 4 11234 5 56789 2 So far this is…
Hello I have been given some data to process daily, it has a date column but its formatted as Text, and has a short month, for example it looks like: 01 Jan Data in DOMO looks like: There is another column that has the full month name and the year (as a month summary) so i have trued to split out the Short and Date Summary…
Input into formula tool is 2019-01-02 07:30:00 AM, formula is STR_TO_DATE(TimeIn1,'%Y-%m-%d %h:%i:%S %p'). Validate formula checks out, but error is Failed to parse date/time: Error at or near character 11 in string /2019-01-15 7:30:00 AM
I have a field with letter and numeric values (ex. "John Doe" vs. "12345"). My goal is to filter to leave the numeric values and change the column type to Integer. Does anyone have any ideas on how to do this in ETL? Trying to think of a Case when statement & filter option.
Hi all, so I want to use the Domo API's to do partitioning. That is, I want to send data daily, and I do not want the data there to be overwritten. I am trying this but I think it is being overwritten: https://api.domo.com/v1/datasets/{dataset_id}/data?updateMethod=PARTITION Is this the correct way to upload via partition?…
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