Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Populate Stream Field with mulitple column/fields?

  1. #1

    Question Populate Stream Field with mulitple column/fields?

    Looking for a way to get a list of values from a CSV that are multiple fields/columns - and the number of Columns are not fixed. This example may help:

    Column1 Column2 Column3 Column4 Column 5 Column6
    nic01 nic02 nic03 nic04 nic05 nic06
    nic02 nic03
    nic01 nic02 nic03 nic04 nic05 nic06
    nic04 nic05 nic06 nic07 nic08 nic09

    I would like to populate a Stream Field, which I will sort and get "unique" values. My question is how can I get a stream field with all values

    Interfaces:
    nic01
    nic02
    nic03
    nic04
    nic05
    nic06
    nic07
    nic08
    nic09

    Hope that makes sense. Thanks in advance!

    KP

  2. #2

    Default

    Ok .. figured it out. I used the Row Normalizer step .. worked. But what if I get a Column7? Is there a way to dynamically update the Row Normalizer step?

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

    Default

    As always, without formal description, it is of utmost importance to choose one's sample data wisely.
    Attached Files Attached Files
    So long, and thanks for all the fish.

  4. #4

    Default

    I wanted to thank you for the transform. Assume I had other columns in the CSV which did not get processed the same way. Again example:

    Column1 and Column2 are not to be processed in the same way. I used the Row Normalizer in my transform, but again not sure if the Columns are dynamic, if that will break. I like your transform, but will it work with example below.

    Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8
    host1 server nic01 nic02 nic03 nic04 nic05 nic06
    host2 server nic02 nic03
    host3 switch nic02 nic03 nic04 nic05 nic06
    host4 router nic04 nic05 nic06 nic07 nic08 nic09

    Thanks as always!

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

    Default

    If your expected output is the same as given before, you simply remove these fields.
    Attached Files Attached Files
    So long, and thanks for all the fish.

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.