Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Transform

  1. #1
    Join Date
    Oct 2017
    Posts
    1

    Default Transform

    Excuse me,

    I have a csv sample data like this
    ID Item1 Item2 Item3 Item4 Item5 Item6 Item7 Item8 Item9
    1 0 0 0 0 1 0 1 0 0
    2 1 0 1 0 1 0 0 0 0
    3 0 0 0 0 1 1 0 0 0

    and then i want to transform into csv file like this
    ID Item
    1 Item5
    1 Item7
    2 Item1
    2 Item3
    2 Item5
    3 Item5
    3 Item6

    Anyone have a ktr sample like that? or how should i do to transform that data?

    Sorry i'm new in pentaho data integration.

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

    Default

    Have fun with Kettle.

    Also, don't forget to read the sticky threads.
    Reading the books on Kettle mentioned there can ease your transition from beginner to expert.
    You certainly found the samples in your Kettle installation folder, did you?
    Attached Files Attached Files
    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.