Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Get specifics values from column to create new lines

  1. #1

    Default Get specifics values from column to create new lines

    Hello everybody.

    I have a problem. I need did columns to separate specifics values. But I need to create new lines with just this values, one row for each column.
    I tried to use row normaliser but it's didn't work.
    Please can someone help me?

    Thanks in advance

    e.g.

    In this example, I removed some columns that I will need, but basically is this I want.

    This is what I have:
    Name:  ihave.jpg
Views: 39
Size:  37.5 KB

    This is what I would want to do:
    Name:  iwant.jpg
Views: 37
Size:  42.4 KB
    Last edited by thiagofred; 03-21-2016 at 02:16 PM.

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

    Default

    It's not that difficult to achieve the desired result with Kettle, but it's not a typical ETL job either ...
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3

    Default

    Thanks marabu. It work's like I want.

    I don't know if is the best way, but is the way that I found, because I have more than 20 excel inputs with about 100 rows each. Then I have to organize this result for each group. The line 83 it was just the line when v_demit and v_afast wasn't 0,00.

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.