Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Output row for each input in a column Pentaho Data Integration Spoon

  1. #1
    Join Date
    Oct 2017
    Posts
    2

    Default Output row for each input in a column Pentaho Data Integration Spoon

    I am new to Pentaho Data Integration, and I am looking to take the below column data and have an output for each entry in the date columns. Not sure how this can be done in spoon.


    I have looked into the Denormalisation step, but examples are not very good that I have found. Also, I am not sure it would get me an output for each column value.

    I am starting with this data:
    Name:  Start.png
Views: 95
Size:  3.1 KB

    Desired output:
    Name:  Finish.png
Views: 102
Size:  4.6 KB
    Attached Files Attached Files
    Last edited by cyates; 10-22-2017 at 10:32 AM. Reason: Attaching Sample Files

  2. #2
    Join Date
    Oct 2017
    Posts
    2

    Default

    I figured out for this we need to use the normaliser step with the below settings.

    Name:  Solved1.png
Views: 102
Size:  5.8 KB

    Results:

    Name:  Solved2.png
Views: 97
Size:  6.9 KB

Tags for this Thread

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.