Can anyone please help on this one.
We have this list reports with around 8 columns.
We put a filter on column5 like this:
Column5 is not null
We run the report but there are still records with that column beeing empty but we don't want those records.
I suspect it because of a LEFT outer join from 2 tables but there seems to be like 4;5 tables involved and inner joins before the outer join. The thing is I'm not sure which columns are the real I'd and that were used on the model via Framework Manager.
How can bypass this left outer join ? Or is it a easier way to filter out the records that contain null(nothing) in column5 ?
You can try the below:
1. Select 'After auto aggregation' in filter properties.
2. Change the filter to Column5 is not null and Column5<>''
second one would be AND, not OR. using OR will return all lines.
Yes you are right. Corrected.