Generally, when joining views together on a condition, only the rows that would satisfy the condition would be displayed. In case the rows that satisfy the condition are not being displayed I would perform the following checks:
* I would check if there are rows present in the source that would match the condition for join the 2 views
* Also, if I wish to keep the specified column in the conversion of columns to Array, I would include the column in the NEST () when performing the conversion, such that the original columns remains even when the array is flattened.
* I would also check the intermediate view that are used in creation of the derived view causing the issue for any conditions in place.
* Finally, I would check the Execution Trace to compare the difference between how many rows are actually being got from the source and how many rows are finally being displayed.
If you still need help and you are valid support user, then you can raise a new Support case at the [Denodo Support Site](https://support.denodo.com/) so that our Support Team will assist you.
Hope this helps!