Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to transform this? newbie question

  1. #1
    Join Date
    Mar 2016
    Posts
    2

    Default How to transform this? newbie question

    Access database
    Name:  Screen Shot 2016-03-14 at 1.02.17 PM.jpg
Views: 27
Size:  30.0 KB

    Access database table relationship
    Name:  Screen Shot 2016-03-14 at 1.04.50 PM.jpg
Views: 26
Size:  19.4 KB

    Desired CSV output
    Name:  Screen Shot 2016-03-14 at 1.11.53 PM.jpg
Views: 27
Size:  18.3 KB

    Need to know which type of transformation required i.e 'combination lookup/update', thank you very much..

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

    Default

    Looks like you want to produce a report.
    Suppression of group fields is a genuine reporting feature, so I suggest you use a tool apt to the task: Report Designer
    I'm not saying that I can't produce the desired output using Kettle, but it doesn't feel right.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Mar 2016
    Posts
    2

    Default

    thank you i will try

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.