Dremio lost data when use function unnest

[jlcornejo]

I have data that I must extract using the unnest option, but in some cases this data can be null.

The issue is that the result is obtained from 2 vds, and the data of vds1 must be kept.

When using unnest, the record is completely removed, for all cases where the field is null.

Below is the example.

This case is lost when using unnest

Is there another way?

[balaji.ramaswamy]

@jlcornejo Are all rows null or only certain rows?

[jlcornejo]

only certain rows.

but based on what i read this is how unnest works. So I will be more careful when extracting data.