Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: exported and filtered by data from csv file

  1. #1
    Join Date
    Oct 2017
    Posts
    10

    Post exported and filtered by data from csv file

    I need to export a data from csv file and after filtre to change some names to numbers.

    Example change Texas in 1, Florida for 2

    I try with the switch-case, but this tool saves the filtered in different files and I want to save the changes in only one file
    and how are over 2000 data, would a hard work

  2. #2
    Join Date
    Feb 2016
    Posts
    22

    Default

    If you only need to map some values to a numeric value, you can try the value mapper component.

    http://wiki.pentaho.com/display/EAI/Value+Mapper

    Hope this helps

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

    Default

    With a lookup step you could use an external dictionary for the mapping - might be better from a maintenance point of view.
    So long, and thanks for all the fish.

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.