Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Splitting a column into multiple columns

  1. #1
    Join Date
    Sep 2007
    Posts
    7

    Default Splitting a column into multiple columns

    I have some data from our ERP in a tab separated file. I need to split one column from this file into multiple columns. Column data to be splitted are separated by commas like this:
    A,B,C
    D,E

    Each value should go to separate colums in the table. The destination column depends on the type of value, which is defined in a separate table:
    TypeCode DataCode
    T1 A
    T2 B
    T3 C
    T3 D
    T2 E
    ......
    So the 2 column lines above "A,B,C" and "D,E" should be put into table as follows:
    T1_Values T2_values T3_Values
    A B C
    E D
    ....

    Types and values are text fields. Is it possible to do that in Kettle?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    No.... not without fidgeting.

    You seem to want to process some proprietary format where you define your own semantics... and unfortunately this is hard to process.

    Sven

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.