Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Set a path in Excel Input using ${Internal.Transformation.Filename.Directory}

  1. #1
    Join Date
    Feb 2016
    Posts
    23

    Default Set a path in Excel Input using ${Internal.Transformation.Filename.Directory}

    Hello,

    I need help.
    I have a big problem with setting a file path in the "Excel input" Step, in fact, I have to use ${Internal.Transformation.Filename.Directory}\Filename.xlsx, but it doesn't work, I always get the error "cannot find file",it works only with the exact path.

    Thanks in advance.
    Last edited by Soukaina; 04-10-2016 at 10:42 AM.

  2. #2
    Join Date
    Apr 2016
    Posts
    4

    Default

    Hi,
    I made a sample transformation implementing an excel input step like you with this variable and it works. But the variable was only filled after I had saved the transformation. Could that be a reason?

  3. #3
    Join Date
    Feb 2016
    Posts
    23

    Default

    Hi,
    That's the reason when you don't use the repository, but in my case, I must use the repository and didn't work this way for me .
    Any Ideas please??

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.