Ask SQL DataFlow questions and get answers from Domo peers
I am working on SQL transformations within Domo and have a requirement to create a SQL dataflow programmatically from a code engine using a Python script via the API. Does Domo provide any API support for creating dataflows?
I removed some data (Deleted dataset updates back to 2/15) and am running an APPEND job, but getting this error, how do I resolve? The Domo server reported an error while performing analysis: 'ERROR:Dataset row count does not match. Expected: 0, actual: 4899545.
I am using the Domo workbench to import data that includes two fields, OrderDate and TransactionDate, which are in date/time format. My goal is to import these date/time values exactly as they are, without any modifications or timezone shifts. For example, if the OrderDate is 8/26/2024 9:00:49 AM, I want it to be imported…
When I run the following query in SQL Server, four date fields (Due_Date, PO_Date, Print_Date, Ship_Date) return the correct date, but when I run my query in the workbench, the resulting 4 dates are -1 day (Example: date when run in SQL Server = 2023-05-04-00.00.00.000000, the correct date, but when run in the workbench my…
I've tried the following 3 things to remove the leading zeros from PO_Number, (using OPENQUERY) in the workbench without success, any other suggestions please? Using CAST and LTRIM: SELECT * FROM OPENQUERY(ACME_CO_PRD, 'SELECT LTRIM(CAST(CAST(fd.PO_NO AS INT) AS VARCHAR)) AS PO_No, 2. Using PATINDEX and SUBSTRING: SELECT *…
I'm creating a card in Analyzer and currently using chart type "Table". Other than changing my chart type to Pivot Table, how else can I sum the totals for my columns……but not all, only some of them?
Hi, I am trying to join 2 tables based on a "date - product" —> columns "year_month_key" and "year_month_lagged_key" My 2 tables are the following transform_data_lagged transform_data_current when i join both table via the following left join statement, i loose the first rows in the left table, "transform_data_lagged",…
I am trying to use the Pivot tile to accomplish the following (in my attached dataset), but am getting no results under the column I am creating (Weekend_Date_Pivot). Weekend Date should now be columns with Demand_Qty as the metric under each Weekend Date
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