Latest Activity

code

JOINING LEFT VIEW WITH PRIMARY KEY TO RIGHT VIEW WITH A COLUMN WITHOU PRIMARY KEY

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

code

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

code

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

code

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

code

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

code

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

code

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

code

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

code

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

code

Isolated query of a joint view

Hello, is it possible to solve the following scenario: I have two views with different sources, which I would like to join (a push-down is therefore not possible). I want to join these views and make them available for reporting. However, the reportin...

Denodo 8.0 performance join