Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BI Publisher for-each-group skip null columns in RTF template — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher for-each-group skip null columns in RTF template

Received Response
12
Views
1
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment

Content

Hi All,

I have a scenario in RTF template, I need to perform for-each-group based on four columns.

<?for-each-group:G_ROWS;./COL1;COL2;COL3,COL4?>

COL1,COL2 and COL3 can be null but COL4 will not hold null values.

When I have null values in the COL1, COL2 or COL3, I need to skip that specific column in the grouping. Grouping needs to be performed on the rest of the columns.

Please let me know how to achieve the same.

Thanks,Xavier

Version

11g
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!