Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: CSV grouping lines with empty values

  1. #1
    Join Date
    Dec 2013
    Posts
    7

    Default CSV grouping lines with empty values

    Hello,
    thank you in advance of the time you'll devote myself. I'm just a network administrator ....
    If you have tracks to reach the transformation I'm interested.
    Event a hints : transformation ? xml ? json

    So, I want a single ligne by NUMBER (unique value)


    my file :
    NUMBER;NAME;COST
    6896;;
    ;JOHN;
    ;;0.2
    9528;;
    ;JACK;
    ;;11.08


    What I want :
    6896;JOHN;0.2
    9528;JACK;11.08

    best Regards

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

    Default

    You want to fold 3 rows into one?
    Here's one way you can do it with Kettle.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Dec 2013
    Posts
    7

    Default

    It works well
    Thank you very much!
    My best Regards

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.