You can translate the question and the replies:

Interpolation variable - Passing value from another base view

I have first base view with interpolation variables. I would like to pass values for them from second base view. To achieve this, I have created a derived view joining first and second base views. it is working fine until there is a null value in one of the columns if second base view. i want to pass null value in this case. but query is giving 0 results. Could you please guide how to pass null value to the interpolation variable?
user
22-08-2018 20:19:32 -0400
code

1 Answer

Hi, In database, ‘Null’ value is an indicator and it isn’t a specific value. Therefore it cannot be passed as the JOIN value of two tables as it is not a matching data. If you wish to do so, you may consider changing NULL values in your tables to an empty string (‘’) and ensure there is matching data in both the join views for the query to return these results. Hope this helps!
Denodo Team
24-08-2018 02:57:02 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here