Search code examples
pentahoetlkettle

Get the repository path in kettle

I struggle to get the full repository path which kettle is using. Reading the help on variables (link) states that I could use either "Internal.Transformation.Repository.Directory" or "${Internal.Job.Repository.Directory}" depending on if it is a job or a transformation. This actually works and returns the path to the file with the repo as root.
Since I need the "full path" to the file (or the repo) - I tried the "${Internal.Job.Filename.Directory}" (and the transformation one) but this returns the string "Parent Job File Directory" (see below).
As additional information - I am connected to a repo.

Wanted the path :(

Mission - How to get the full path to the file (job/transformation)?

Solution

  • The directory of the caller of the transformation is the ${Internal.Entry.Current:Directory}. This is because a job can contains a job so what matters is the directory of the entry in the job.

    Note: If you run the transformation directly, rather that call it from a job, the Internal.Job.Filename.File will be the generic "Parent Job File Name" rather that "".

    enter image description here