Latest Activity


join two tables, but sum up right table first

Dear All, i want to join two tables. On the left is the heading table and on the right there are multiple rows with different amounts for example: Name. I want to sum up the amounts on the right to join only one row to the left table. How can I i...

sum join Group By



Hello. I have a view named left_view with 5 rows: column_1 column_2 column_3 abc some value some value def some value some value ghi some value some value ...

Duplicates Distinct primary keys join left join


Error Saving View When Joining to Same Table Multiple Times

I'm trying to create a derived view using the Denodo Design Studio web app. Let's say I have two views: DERIVED_VIEW and BASE_VIEW. These two views have a one-to-many relationship (DV-to-BV). I'm trying to create a new derived view which uses DV as the...

derived view join


Limitations on derived view (JOIN)

Hi All, we have derived view (JOIN) created with 15 tables (14 joins) and planning add additional logic which will bring 10-15 joins additonally . Could you please let me know if there will be any limitaion on that ? Thanks, Ravi

limitation hash join join


Join is not recognizing the same data (type text) in the fields and returning null values

I have 2 views. Each of this view has a field unit with the type text. I want to join these 2 views over this unit field. When I tried to do it though, I realized that somehow Denodo doesn't find matching values. So it returns an empty view. The ty...

Data Type Conversion join Data Modeling


Can I return join conditions and filter conditions programmatically?

For example, I can use a predefined stored procedure such as column dependencies to get a field calculation expression. Are there are any stored procedures that provide access to the join conditions and where clause conditions in the dependencies of a ...

Denodo stored procedure Filter data lineage join


Join Views with fields that have similar data, but not identical

Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field ...

Excel join


Json array in data set - joining back to original data --- losing records when select * is used

I am seeing some odd behavior with a derived view that is the result of a field with JSON data being turned into an array and joined back to the original data set and the flattened. if I do a select * (no where clause) of the resulting join (after th...

select query flatten ARRAY missing records JSON join


Condition based Join of 3 tables

I am having 3 tables - A, B, C. I need 4 kinds of output Case 1 : If condition 1 and 2 both not satisfied : Sel from A Case 2 : If condition 1 satisfies : Sel A. from A Inner Join B Case 3 : If condition 2 satisfies : sel A. from A Inner Join C Case ...

join CASE switch


Joins with Paginated Data

If we have a schenario where results from two paginated APIs are to be JOINED. e.g. We have 1 million customers, and an API that returns 100 at a time. And another API that reutrn All Customer Orders, again 100 at a time, with no guarantee about what p...

Pagination join