Ask Magic ETL questions and get answers from Domo peers
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?…
I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data. in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as…
I have a question. I am using APIs now and I would like to know if it is possible to do partitioning using APIs. I know using Magic ETL and using Workbench you can do it, but can you do it using APIs? If I can't is the next step doing recursion? The reason for asking is that I am uploading data daily and would like to add…
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 DomoAI and get answers 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