Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Value conversion

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Value conversion

    Attachment: Test Percent Textfile.ktr Hi there,


    I am a newbie busy evaluating kettle for our company. I am busy putting through some of our existing processes and I find this product to be fantastic. However, I am busy with a specific process and I have, what I think, is a basic problem and I can't seem to solve this.



    I have a comma separated text file as input. The first column is a description and the second column is a percentage. The client that I receive this file from is putting a percentage sign at the end of the percent. ie. "5.75%". I need to write a script that will convert this to 0.0575. is this possible and how do I accomplish this.



    thanks



    anon

  2. #2
    Join Date
    Nov 1999
    Posts
    459

    Default RE: Value conversion

    Attachment: Test Percent Textfile.ktr Hi anon,

    you simply add a culculator step and divide by 100.
    A sample is attached.

    HTH,
    Jens

  3. #3
    Join Date
    Sep 2005
    Posts
    1,403

    Default RE: Value conversion

    thanks a million, it works like a charm

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.