Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Understanding row flattener

  1. #1
    Join Date
    Dec 2015
    Posts
    5

    Default Understanding row flattener

    I am importing a text file that looks like this: (There is a CR at the end of the first line)

    PICKCOMP|00382138|5|2|30514|V0000101844|12042017 075333839|
    PICKLOC|632303|2

    The import is handling the file like this:

    Hdr-> Field1,Field2,Field3, Field4, Field5, Field6, Field7, Field8
    Row1-> PICKCOMP 00382138 5 2 30514 V0000101844 12042017 075333839
    Row2-> PICKLOC 632303 2

    I am trying to get this result:
    Hdr-> Field1,Field2,Field3, Field4, Field5, Field6, Field7, Field8, Field9, Field10, Field11
    Row1-> PICKCOMP 00382138 5 2 30514 V0000101844 12042017 075333839 PICKLOC 632303 2


    I have been unable to use row flattening to make this work. Is there any other method to accomplish this?

    Thank you in advance for any ideas!
    Chris

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

    Default

    If I'm understanding right, you're looking for line continuation, not row flattening.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Dec 2015
    Posts
    5

    Default

    Yes this is exactly what I was trying to accomplish. Very interesting solution, thank you very much! Appreciate it.

    Chris

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.