Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Manage outlier with Denodo
answered 17-01-2020 23:47:36 -0500

Good afternoon, how can I manage the outlier in Denodo. Verify that they exist and then be able to eliminate them. It is to say from a list of quantities I have values that are exaggeratedly high or exaggeratedly low that will interfere with my data....

Answers: 2

How to get file modified date for an excel file in FTP location
answered 17-01-2020 17:47:30 -0500

We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...

Answers: 1

File Modification Date

Configure fields to ungroup or group dates
answered 15-01-2020 13:57:06 -0500

I want to make an integration of data where I can manage the date, that is to say a type of query for a period of time. Weekly sales, monthly sales, among others. Greetings from Ecuador.

Answers: 2

Using Denodo VDP admin database as source from Talend
answered 15-01-2020 13:33:47 -0500

I got Denodo AWS trial environment and trying to use Denodo as the source from Talend Data Catalog tool to test the metadata harvesting. I tried to use 'jdbc:vdb://ec2-54-175-90-97.compute-1.amazonaws.com:9999/admin' with 'admin/admin' as username/pwd ...

Answers: 1

aws free-trial

Load data from Google Sheets
answered 15-01-2020 10:24:47 -0500

Hello, I'm trying to load data using the Google Drive API from Google Sheets with Denodo. I followed the steps described here: https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Google%20Sheets%20Tool%20-%20User%20Manual an...

Answers: 1

Google Drive API

Fail query if filenames do not exist in path
answered 14-01-2020 12:03:16 -0500

Hi is it possible to fail the query if the required files are not in the path? I tried this, but in the path it is nos possible to set regular expressions (anychar). PATH /path/PATTERNAME_^DateRange("yyyyMMdd",@startdate,@enddate,"yyyyMMdd")(.*) <...

Answers: 1

Collecting Field wise stats without using CSV
answered 14-01-2020 08:45:13 -0500

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?

Answers: 3
Related to: How to update the statistics of a view automatically

Automic scheduler Gather Statistics Generate stats

Populate Denodo view parameters from another table / sub query
answered 14-01-2020 07:30:27 -0500

Hi, I have a view with two data parameters as below SELECT * FROM people_data WHERE effective_date >= in_from_effective_date AND effective_date <= in_to_effective_date USING PARAMETERS ( in_from_effective_date : DATE CURRENT_DATE(), in_to_effec...

Answers: 4

Delimited File Error
answered 14-01-2020 07:10:08 -0500

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Answers: 1

Base view Delimited Files

To add a parameter to a derived view
answered 14-01-2020 02:37:03 -0500

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Answers: 3

Parameter View Parameter entry derived view