Avoiding blanks on table

[NavinReddy]

Dear Experts Good Afternoon,

I am trying to avoiding the blanks on straight table.

with this blanks on straight table the FACT numbers its repeating multiple time. Any way to avoiding

please suggest me

for reference i have attached the image

Thanks,

Niru

[amit_saini]

Hi,

Try to change this to Pivot table!

Thanks,
AS

[Digvijay_Singh]

Try these -

1. check 'Suppress When Value is null' in dimension tab

2.'Suppress missing and zero values in Presentation tab.

But out of many expression, even if one expression has value and others having null, that row will be shown.

Regards,

DJ

[NavinReddy]

Hi both the logics i have tried not worked

any other way to resolve this issue on script side

For only 3 fields, please suggest

[maxgro · Accepted solution]

if your fields are in a single table, you can add a where condition to the load

to remove the rows where all the fields are null, something like (the fields are d1 d2 d3, replace with yours)

load

     ......

from

     ....

where len(trim(d1)) or len(trim(d2)) or len(trim(d3));

[MarcoWedel]

Hi,

as only ever one of your Risk, BD and Resource fields has a value, I suggest to review your data model.

hope this helps

regards

Marco

[vikasmahajan]

While loading script  you can check dimension  like this isnull(Risk) or len(Risk) = 0  as flag , and skip this records in set analysis.

Vikas

[NavinReddy]

Thank You its working