Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Row Denormaliser aggregation not working?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Row Denormaliser aggregation not working?

    Hello chaps,

    I have the attached Row Denormaliser step. It takes stock adjustment codes and quantities and denormalises them into "flat" fields.

    The key is the so-called Reason (reason code for the adjustment). There are cases in which several reasons must be added into one denormalised field. For example, reasons 27a, 27b, 27c... all go to the 'qty_credit' field.

    As far as I understood, if I put the same target name and an aggregation function, the step would aggregate all into that target. Following the former example, setting all 27x reasons to go to target qty_credit with SUM aggregation should sum all of them into one field. Am I right?

    The actual behaviour is that the step is creating new fake fields like qty_credit_1, qty_credit_2, etc, and does not sum the values in the main field. Am I doing something wrong?

    Thanks for your help,

    --
    Julio.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.