Oracle Analytics and AI

RTF file Configuration for Eliminating Null Value Column

I am creating an RTF file using Word table with 3 fixed columns and another 4 columns that I do want to show the non null columns

If a column is totally null values i don't want to show, is that feasible ?

There is no straightforward way of achieving it. However, you can try below approach:

Create an RTF template with 4 different tables. First table will have only the 3 columns which are always displayed.
Second table shall have 3 mandatory + one optional column and so on.
Create 4 temporary variable at RTF level. Initialize them to 0 and loop through the data set to get the number of values for 4 optional columns in each temp variable.
If all 4 are having 0 values, display first table.
If any of the temp variable is having a value, display the second table (3 mand + 1 optional) and so on.

Thanks.

There is no straightforward way of achieving it. However, you can try below approach:

Create an RTF template with 4 different tables. First table will have only the 3 columns which are always displayed.
Second table shall have 3 mandatory + one optional column and so on.
Create 4 temporary variable at RTF level. Initialize them to 0 and loop through the data set to get the number of values for 4 optional columns in each temp variable.
If all 4 are having 0 values, display first table.
If any of the temp variable is having a value, display the second table (3 mand + 1 optional) and so on.

Thanks.

Thanks!