-
Workbench job that I created on 2/25 & set to append one day back, scheduled job ran multiple times
I built a workbench job on 2/25 & set it on a schedule to append with the logic at the bottom (appending one day in the past at a time). Even though I had it scheduled for once daily, for some reason the job the job ran twice as a "scheduled update". Any idea why this might happen, and is there any documentation of…
-
How Do I Resolve This Error: ERROR:Dataset row count does not match. Expected: 0, actual: 4899545
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.
-
How to import date/time values in workbench exactly as 8/26/2024 9:00:49 AM, without any transform?
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…
-
Why are all of these dates (Due_Date, PO_Date, Print_Date, Ship_Date) returning the date - 1 day
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…
-
Removing leading zeros from PO_Number, (using OPENQUERY)
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 in Analyzer, how can I sum the totals for only some of my columns
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?
-
Why Is the Pivot Tile not Working as I Expected
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
-
Error in workbench, Dataset is currently locked and cannot be executed right now
I created a dataset with the following SQL query 6/1/24, and on 8/8/24 I began getting the following error: The dataset is currently locked and cannot be executed right now. The likely cause is the Job is open in the UI or has unsaved changes. I have confirmed that the job is not open in the UI and has no unsaved changes,…
-
in the Domo workbench, can't separate TransactionDate (date/time format) into 2 pieces
I have created a job in the Domo workbench with the following SQL query, but in my resulting dataset, "Transaction_Date" and "Transaction_Time" are not splitting into two columns, one with just the date (2021-09-02) and the other just the time (01:00:21.000)….I am still getting both (2021-09-02 01:00:21.000). I have also…
-
How to combine multiple values for one item separated by a coma
There are multiple lines (column titled: PO Number, one on each line) for a given item number in my data. I want to combine all of the results for PO Number so they appear on one line, separated by a comma (shown at the bottom). Item Number PO Number 63631 235084 63631 231656 63631 227775 63631 235084 63631 231656 63631…
