Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to process the data value with the dolar sign in from of the salary

  1. #1

    Default How to process the data value with the dolar sign in from of the salary

    for instance, I have the row data as below;

    name sex phone salary

    mike m 404-567-7890 $125,000


    in SAS the salary can be applied with the format first then do the calculation on the salary. in kettle, do we have something similar in order to calculate the correct result?

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

    Default

    For calculations you must convert the String salary to a Number first.
    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.