Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Summary

  1. #1
    Join Date
    Feb 2016
    Posts
    8

    Lightbulb Summary

    Hi all,

    I'm trying to make a summary of this source:

    Price Company Product
    5305 Company 1 Prod1
    5305 Company 1 Prod1
    5785 Company 4 Prod1
    5785 Company 2 Prod1
    5785 Company 4 Prod1
    11569 Company 4 Prod1
    23138 Company 4 Prod1
    32592 Company 1 Prod3
    41531 Company 1 Prod3
    63014 Company 1 Prod4
    66466 Company 4 Prod1
    66466 Company 2 Prod1
    245140 Company 3 Prod2
    245140 Company 3 Prod2
    245140 Company 4 Prod2
    245140 Company 4 Prod2

    The main idea is get a summary like this:

    Quantity Total
    Company 1 147747
    Prod1 2 10610
    Prod3 2 74123
    Prod4 1 63014
    Company 2 72251
    Prod1 1 72251
    Company 3 490280
    Prod2 2 490280
    Company 4 603023
    Prod1 6 112743
    Prod2 2 490280
    General Total 1313301

    I appreciate in advance any idea that can help me.

    Best regards,
    ThinkWario

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You want to use a report tool (like Pentaho Report Developer) rather than an ETL tool.

  3. #3
    Join Date
    Feb 2016
    Posts
    8

    Default

    Quote Originally Posted by gutlez View Post
    You want to use a report tool (like Pentaho Report Developer) rather than an ETL tool.
    Sadly, i havent any kind of report tool, and i don't know if can i add it to the actual version of spoon (4.2.1)i was wondering how to do this by ETL :/

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    You wouldn't add it to PDI, you'd run it beside
    https://sourceforge.net/projects/pen...rt%20Designer/

    If you were to absolutely have to do it in PDI, you'd have to figure out a sort order, which would allow you to operate on the different pieces of your data separately, and then merge them and sort them. But the *RIGHT* way to do this is with PRD.

  5. #5
    Join Date
    May 2013
    Posts
    16

    Default

    try microsoft excel~

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.