Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Pull particular cell value from Excel

  1. #1
    Join Date
    Sep 2011
    Posts
    171

    Default Pull particular cell value from Excel

    Hello Everyone,

    I would like to get particular cell value from Excel, not a table, but just single cell value. I tried Excel Input, but it keeps giving me error.


    Here is what I would like to accomplish

    I have data

    Date
    09/12/2011 <- this is in the cell A1

    Product name, Quantity
    Chair, 12
    Table, 13

    I would like to end up with:

    Product name, Quantity, Date
    Chair, 12, 09/12/2011
    Table, 13, 09/12/2011

    Any ideas?

    Regards,
    Alex

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hey Alex,

    depending on the actual layout in the Excel file you'd have to do it slightly differently. If you could post a sample file, maybe someone will create a sample for you.

    Cheers
    Slawo

  3. #3
    Join Date
    Sep 2011
    Posts
    171

    Default

    Thank you!

    Here is an example. I included two worksheets: WhatIhave and WhatIwant. I guess the names are self explanatory. The values for the date column are taken from the cell A2.

    Regards,
    Alex
    Attached Files Attached Files

  4. #4
    Join Date
    Sep 2011
    Posts
    171

    Default

    I got it with Job, Set Var and Get Var and usual Excel Import component.

    Thank you!

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.