Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Group Data from Transformation and Save as a Document with an Array field in Mongo DB

  1. #1
    Join Date
    Oct 2016
    Posts
    19

    Default Group Data from Transformation and Save as a Document with an Array field in Mongo DB

    Hello,

    I am having hard time to wrap my head around it...

    So there is a transformation which returns data with a field which has repeating values. I need to group by that field and save the grouped items inside an Array field of the document in Mongo DB.

    Included is transformation and screenshots of what is input and expected output. Could you please help?

    Thanks in advance!
    Attached Files Attached Files
    Last edited by tk1977; 10-07-2016 at 09:58 AM.

  2. #2
    Join Date
    Oct 2016
    Posts
    19

    Default

    Nobody can help?

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Basically, you just added a MongoDB-Output step and clicked "Get Fields".
    You need to structure your output document by specifying pathes.
    Didn't you read the Wiki page?
    So long, and thanks for all the fish.

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.