Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dynamic columns without header. How to read as one column ?

  1. #1
    Join Date
    Mar 2013
    Posts
    66

    Default Dynamic columns without header. How to read as one column ?

    Hi,

    Thanks in advance for your support.

    I have an input file as shown below,

    Field1;Field2;Field3;Field4
    val1;val1;val1;val1
    val2;val2;val2;val2;valExt2
    val3;val3;val3;val3;valExt3
    val4;val4;val4;val4;valExt4;valExt4
    val5;val5;val5;val5;valExt5

    How can I read these extra columns values as Field5 ?. The customer says the columns are dynamic after field 4. That is, till Field4 we have fixed columns and later there might be increase/decrease in the columns.

    That is Field5 should contain,

    Field5
    valExt2
    valExt3
    valExt4;valExt4
    valExt5
    Please advise

  2. #2
    Join Date
    Sep 2007
    Posts
    16

    Default

    Hi,

    you could read in the whole lines into one field and use a RegEx step to capture groups afterwards.

    Regards
    Seyhbold

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.