Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: First Project on Kettle

  1. #1
    Join Date
    Feb 2017
    Posts
    7

    Default First Project on Kettle

    Hello people... I'm not having a problem. I Just dont know how to resolve this....

    In this moment, i have the folowing rows:

    MeterID;idLinea;idLineaPadre;CollectorSerialNumber;DataDate;HourlyConsumptionInPulses00_01;HourlyConsumptionInPulses01_02
    1;785;785;163001755 ;;;
    ;786;785;;2016-10-31;0;0
    ;787;785;;2016-11-01;0;0

    2;793;793;163001755 ;;;
    ;794;793;;2016-10-31;11;1
    ;795;793;;2016-11-01;0;0

    I need to transform this on 4 rows. Combining the red one, with the 2 green ones.

    Then i would perform a select that will present the data as follows:

    MeterId; CollectorSerialNumber; DataDate; Hourly
    1; 163001755; 2016-10-31; 0
    1; 163001755; 2016-11-01; 0
    2; 163001755; 2016-10-31; 11
    2; 163001755; 2016-11-01; 0

    The question is: how do i perform this "join" / Combination/ Better Group By... dont know what to use.

    Name:  Transformation.jpg
Views: 22
Size:  14.6 KB


    Thanks in advance

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

    Default

    Yes, Group-By is it.


    Name:  218932.png
Views: 22
Size:  7.1 KB
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Feb 2017
    Posts
    7

    Default

    I really apreciate your helping.... you gave me all solved... im gratefull
    So, te key of the solution is the agregation on the group by... i knew it was possible, but didnt know how to:


    Name:  solution.jpg
Views: 20
Size:  24.8 KB

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.