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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    How to exclude null values in eText output using RTF template

    in Reporting and Analytics for HCM 3 comments

    Summary:

    Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e. it always has data. If the remaining 20 columns are null I want the layout to prevent it from generating those rows. How to achieve that.

    Please note:

    1. Even if one col of the 20 cols has data the entire row should come through
    2. If ALL 20 cols are blank only then do not generate that row

     @Kevin M-Oracle

    Content (please ensure you mask any confidential information):


    Version (include the version you are using, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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