-
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…
