-
trying to handove workbenh uploads to someone else - errors
I have been using workbench for several months to update a domo table with some data, with no problems. I need to hand over this piece of work to my agency. I got our contact at the agency to download and autheticate workbench, plus I exported the dataset job and she imported it. However, when she tried to upload the data,…
-
Lost all my dataset jobs
Workbench suddenly, and seemingly for no reason, lost all my dataset jobs - is there any way of restoring them?
-
Streaming result set error when trying to run a data flow
I have a data flow, which has been working but which I have modified. But I can preview every part of it and get valid SQL returned, and yet when I actually run it I get this. Any ideas? "The database reported a syntax error. Streaming result set com.mysql.jdbc.RowDataDynamic@232401f9 is still active. No statements may be…
-
Converting currency
I have some data which contains revenue but in USD, because the data vendor is US-based, but all our other numbers are GBP. Any ideas on a way to convert tjhis into GBP? Perhaps pull some public currency data into a table and then I can do a currency calculation in beast mode or a tranform? Mainly interested in where and…
-
Connecting to a data source via API
Hi there I have a data source which only has 2 options: manual extract of daily files from a portal OR API I am not a developer, but can usually work things out in time i.e. I taught myself HTML, CSS and JS in order to complete a certain task - however at the moment I don't really have time do a lot of learning just to get…
-
Import CSV via SFTP where private key is required
Hi is this possible? A data provider requires a private key to be imported into an SFTP client, but can this be done in domo or workbench?
-
YoY analysis without time series
I work in the hotel industry and, due to the season nature of travel demand, virtually all reporting has some element of YoY comparison to it. However, I am struggling to see how I do this in Domo - it seems like a real limitation. I can easily create a chart of revenue over time where this year is compared to last year,…
-
Struggling with appending data to progressively build up a dataset
Hi there - I am using Google Sheets to create 2 separate reports (identical structures) of Google Analytics data, the reports are for [dyanmic] yesterday and then scheduled to pull into Domo each day. There are then some transformation things I am doing to it in magic ETL to create an output dataset - I append them…
-
Append data when columns missing from input data
Hello. I have a master dataset in domo which was originally extracted from a legacy system, and has 'timestamp' and 'id' columns which were specific to the legacy data set. New data is identical but with the exception of the fact that it doesn't include those columns. It seems if I try to append the data to the master data…
