Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Problem with “Create a copy or Field” in Kettle - Pentaho

  1. #1
    Join Date
    Mar 2016
    Posts
    19

    Default Problem with “Create a copy or Field” in Kettle - Pentaho

    I'm facing this strange result with pentaho and a "Calculator" step. I've got this flow.

    Name:  bKT3T.jpg
Views: 57
Size:  9.9 KB

    I need to copy one of the column coming from the 'Setting - Location' input step. So I use a calculator (I need to use it in another transformation). However when I see the result I'am getting this.

    Name:  Resultado2.JPG
Views: 54
Size:  30.5 KB

    'Location' is the columns that should be equal to 'City code'. But at the end I see this result that I have not been able to understand it.
    What could be happening?

  2. #2
    Join Date
    Mar 2016
    Posts
    19

    Default Doubt with Calculator Step in Kettle.

    Hi there

    I've got this flow:

    Name:  bKT3T.jpg
Views: 58
Size:  9.9 KB

    What I want to do is to copy a column from the lookup step (City Code to Location). However the result is strange:

    Name:  Resultado2.JPG
Views: 61
Size:  30.5 KB

    I made a test using a data grid instead the csv input and I did not have any problem.

    What could be happening?

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

    Default

    There's a feature called Lazy Conversion in your CSV-File-Input step.

    Turn it off and you should be fine.
    So long, and thanks for all the fish.

  4. #4
    Join Date
    Mar 2016
    Posts
    19

    Default

    Thanks a lot. That was the solution!

  5. #5
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Turn lazy conversion off in your CSV input.
    There might be other ways to do this, but this is the fastest one to explain.

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.