RTF file Configuration for Eliminating Null Value Column

Nilesh Kumar Mal-Oracle

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 ?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24217/rtf-file-configuration-for-eliminating-null-value-column

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

1. Create an RTF template with 4 different tables. First table will have only the 3 columns which are always displayed.
2. Second table shall have 3 mandatory + one optional column and so on.
3. 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.
4. If all 4 are having 0 values, display first table.
5. If any of the temp variable is having a value, display the second table (3 mand + 1 optional) and so on.

Thanks.

Nilesh Kumar Mal-Oracle

Thanks!