Q&A BY TAG 'join'

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

Join is not recognizing the same data (type text) in the fields and returning null values
answered 23-11-2022 14:05:13 -0500

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...

Answers: 1

Data Type Conversion join Data Modeling

Can I return join conditions and filter conditions programmatically?
answered 21-10-2022 12:42:33 -0400

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 ...

Answers: 2

Denodo stored procedure Filter data lineage join

Join Views with fields that have similar data, but not identical
answered 29-12-2021 05:25:21 -0500

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 ...

Answers: 1

Excel join

Json array in data set - joining back to original data --- losing records when select * is used
answered 11-08-2021 06:58:14 -0400

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...

Answers: 2

select query flatten ARRAY missing records JSON join

Condition based Join of 3 tables
answered 10-08-2021 13:41:59 -0400

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 ...

Answers: 2

join CASE switch

Joins with Paginated Data
answered 29-04-2021 13:48:58 -0400

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...

Answers: 1

Pagination join

Isolated query of a joint view
answered 16-04-2021 08:35:01 -0400

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...

Answers: 1

Denodo 8.0 performance join

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

VQL Denodo 7.0 search methods join Derived views

Dynamic Base View based on another Base view (not JOIN)
answered 04-01-2021 12:18:07 -0500

Hi, I need help with a very specific use case. I have 2 different data sources and I need to create a base view from source A filtered by some values from another base view coming from source B. This values in the second view would be a hole column, ...

Answers: 5

Dynamic Interpolation Variables Create Base View join

Join condition on delimited files
answered 26-11-2020 04:20:16 -0500

Hi Team, I want to join 2 views.First view is created from Json file and second view is created from delimited files(Text Files) I need to join both of them on basis of one coloumn. This column can be easily written by specifying view name and then ...

Answers: 1