-
Is there a way to add unique id or constant to workbench
I am seeking to aggrigate a historic set of data. The problem is the data pull date, a critical peice of identification, is stored in the title of the report - and does not exist in any of the fields. There is no way to identify WHEN in time the data in a row exsisted, or if it differs from the next time that identical row…
-
add domo account
in the add new account section, where do i find my domo server name?
-
Filter out junk data
There is a dataset I import using Workbench, then transform using Magic ETL. The data includes values between 1-10, but sometimes will contain a random junk value like 324568. I'd like to filter out all values that don't fall between 1-10, but can't find a way to do this wihtout specifying every possible junk value, ie.…
-
Automating Multiple Imports
I am very new at using workbench so sorry if this question is too stupid to even consider. Essentially I want to pull a report for a partition of data. For example select * from tables where GroupType = somenumber Instead of creating a new job for every iteration of somenumber I was wondering if I can have Workbench…
-
Last 30 days Workbench / SQL
Hi Domo friends, I want to query data via workbench but the backend table I'm pulling from is unnecessarily big. I want to limit the date from to the last 30 days from the current day and have it replaced every day. My inclination is something like: `select * from 'data_source' where 'day' = {!lastvalue:day!} - 30 but I'm…
-
Workbench Scheduler to Batch Run Jobs
First some background...there are 6 Jobs that I need to run in Workbench every day. The source data becomes available at different times and I need to manually format the sorce files for all 6 before upload, so I can't set a daily time schedule to automatically upload. The last of the 6 uploads triggers an ETL to run, so…
-
WB Custom Date Format to working for 20180704130000 format
Hi I am unable to get the following format date 20180704130000 (or 2018/07/04 13:00:00) using the workbench data transform. As I see it the Date Format I should use would be yyyyMMddHHmmss Schema for the filed is set to STRING as suggest in the topic below. I had a look at the following dojo topic and article but I still…
-
Port number used for workbench to upload data to the domo cloud
Can I know the port number used for workbench to upload data to the domo? We have own internet server and need to configure the network port just in case it got blocked
-
Where do I go to install Workbench?
In your instance of DOMO click on the following: * Click on the Arrow Menu * Click on Admin * Click on Tool Downloads * Click on Download Domo Workbench
-
Workbench Error
I began receiving the error over the weekend while trying to execute workbench jobs that have historically ran successfully. The error message "DomoApi.Exceptions.IndexingFailedException" did not help point in a direction for fixing the issue. Have anyone run into this before?
-
Export All Workbench Jobs?
Is there a way to export all of our workbench jobs to make a copy/backup as a failsafe in case our workbench server goes kaput? I see how to do one at a time. Maybe I'm just not seeing the option?
-
How do I to get the Watch File function to work?
I seems pretty straight forward, select "Watch File" instead of schedule update every 15 min or something else, but I have tried it with some 40 jobs and not a single one job has ever updated automatically that way. Even after a couple of days an several cahnges to the files it never works. All our files are on our server…
-
Upgrading to Workbench 4
Hello, We want to let you know that Workbench version 2 and 3 will be discontinued on April 28. Any jobs still running on Workbench 2 and 3 will need to be upgraded to the latest version of Workbench to continue running. This comes with some added benefits and significant improvements in the UI experience. What happens if…
-
Primary lookup column not found
Hello, I am trying to extract data from cube to DOMO to built my card. I had created few datasets in workbench and tried extracting data. few of then running fine and some of them getting failed with below error message. The only change in all the queries is selection of time period. i have selected Q1, Q2, Q3, Q4. Q3 got…
-
Set Workbench Job to Pull in Most Recent File
Is there a way to have a Workbench 'Local File Provider' job look for the most recent version of a file (based on the Date modified) so long as the naming schema for the file is consistent? I have a report that autoexports out of one of our software systems, but the file name when it exports is always…
-
Using replacement variables
Hi! Could someone teach me how to use replacement variables? I want workbench to update the latest day in the data set everyday. (but the data set has a two day lag) 1. I'm not sure what exactly to put in the values column. 2. I'm also not sure how to format the day in the query. - Right now I have it set as day >=…
-
What does "Lock Data Type" mean in Workbench 4?
I've found importing Excel datetime values a bit tricky and am using Workbench to fix glitches. The values are formatted in a way that works correctly on most columns, but some still come through as text. So I use the Schema tab to set the field type to DATETIME which seems to do the trick. I've noticed an attribute on the…
-
Loading DD-MM-YYYY Date Format from CSV file with Workbench
Trying to load via Workbench a CSV file (with path to local file). One of the columns have date values with DD-MM-YYYY format and I wish that the "type" on the dataset shall be Date. Is there a way to use "Transforms" or anything else to load properly in DOMO?
-
Any Success Using Workbench in Parallels VM on a Mac?
Hey all, I'm considering running Parallels on my Mac in order to be able to use Workbench from my Mac, instead of switching over to my Windows machine. Has anyone tried Workbench in Parallels on Mac, and if so, how successful/frustrating was the process? Thanks!!
-
How to create an ODBC connection to an MS Access Database that is saved on a local Hard Drive?
How to create an ODBC connection to an MS Access Database that is saved on a local Hard Drive? * I could not add a DSN because of limited admin privilages in my desktop <- Ruled Out * I don't know the exact Configurations/Steps to put in the Connection Builder for MS Access * I don't know the Syntax to put in the…
-
Asynchronously run custom workbench plugin
Hi, I am currently working on creating a custom plugin for workbench 4.5. My goal is to query multiple data sources within a single DataReader. This is required because the data in my organization is sharded across multiple databases, but the tables across the databases all have the same schemas. I have successfully…
-
QuickBooks - Profit and Loss Budget vs Actual report whole year instead of year-to-date? (WB 4.0.6)
In Workbench 4.0.6, is it possible to set the Quickbooks "Profit and Loss Budget vs Actual" report to display data for every month in the year, instead of just the year to date?
-
Workbench doesn't process all rows in *.csv file
Hello, I'm uploading a .csv file through Workbench. Some of the rows (around 3%) failed to upload without any warning. Oddly enough, all of these rows also happen to have a column A that starts with a hashtag. If I delete the hashtag, that row will be uploaded into Domo without any issues. What's the matter? Please help…
-
How to see Workbench version
Hi, what is the best way to confirm the version of Workbench running on my PC? This software does not have a menu option like "About DOMO Workbench" which usually shows the software version.
-
can you update any data from domo workbench to the database?
can you update any data from domo workbench back in to the sql server database?
-
Use workbench to access API behind firewall
We have a few APIs that are behind our firewall (i.e. Domo cannot reach them). Is it possible to make calls to those APIs (just a simple GET request to a URL) and then send the resulting data up to Domo? I have the workbench installed and set it up to push JIRA data to Domo and it works great. I tried creating a new…
-
workbench odbc
Hi, Trying to execute a Workbench job uploading on-premise Oracle data to Domo through ODBC. The error I am getting when executing workbench job was "Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 54.210.83.139:443"…
-
Is there a way to add a date to workbench update
Is there a way to add a schema column for date for when the data was sent over? From what I've seen, this is not possible, but there may be an optinon I missed or a workaround with SQL For example, the Google Analytics connector adds a _BATCH_LAST_RUN_ column, which is similar to what I want but for workbench jobs. This…
-
WB 4.5 Lookup Transform bug/error (Not present in WB 4)
Since updating from WB 4 to 4.5 the lookup transforms not no longer work properly. I keep getting "Object reference not set to an instance of an object." on most of the jobs that have lookup transforms. I think I isolated the problem to jobs that have more than 1 lookup transfrom. It worked perfectly fine on WB 4.0. I have…
-
Domo Workbench importing too many rows
I'm importing a table from my DataWarehouse (Microsoft SQL server). The workbench is telling me it imported ~51M rows, but checking the database, I only have ~46M rows in the table. So it is somehow importing ~5M rows that don't even exist. Has anyone seen this?