Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Removing field x changes value in field z

  1. #1
    Join Date
    Jul 2009

    Default Removing field x changes value in field z

    Here is an error I absolutely cannot understand:

    I have a "select values" step which I use to remove some fields (for example x and y). This step is used to remove some fields only - nothing else.

    Furhtermore, there is a field of type "number" called z. After removing the fields x and y in the step above all the digits in z are gone!
    (Example: z before was 5,98 and after is 5)

    What do I do wrong??? Please advise

    Edit: The number value is created in a formula step by taking a string and calculating 0+string value. Is there another way for conversion?
    Last edited by ölkjh; 07-21-2010 at 12:23 PM.

  2. #2
    Join Date
    Oct 2008


    Unable to duplicate in PDI 4.0.0-stable. Can you post an example?

  3. #3
    Join Date
    Jul 2009



    First of all I would like to thank you for your fast reply! Meanwhile I found a solution though I cannot exactly say what made the success.

    The basic changes to my previous transaction are:
    - I changed the get variable step which is inbetween the input and the step where the failure occurs.
    - I introduced another select item step where I convert the string to a number by changing meta-data to new type. Then I can do the correction with numbers and don't have to create new types in the "formula" step.

    Have a nice day

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.