Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: input excel cell value as string not formula

  1. #1
    Join Date
    Feb 2017
    Posts
    7

    Post input excel cell value as string not formula

    hii
    i am new in pentaho(kettle) i getting problem from excel input step.
    i fetching data from excel thats some field contain formula and some filed not when set formatter ####.##% non formula filed get exact value like 4.5% but those field contain formula that return 100 time multiple value like if original value is 4.5% from formula that give 450%.if dont use formatter then formula cell give correct result but non formula cell give divide by 100 result like 4.5% 0.0045 how to solve this problem there is any way that get only value of that costume field.
    Last edited by mkumar716; 02-04-2017 at 04:25 AM. Reason: not competently explained

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

    Default

    Help may come faster, if you attach a sample transformation.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Feb 2017
    Posts
    7

    Default

    thanks for replay

    i have attached a sample file there is two sheets i need result in common format how i could achieve that
    Attached Files Attached Files

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

    Default

    The sheets don't share a common layout.
    You can easily account for cell blocks having different origins (top left cell), but field lists don't match either.
    You'll have to read each Sheet in a separate transformation.
    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.