CODEWITHSUNDEEP
parameter-passingpentahotransformationjobskettle
d2907
d2907

Reputation: 902

Passing a path as a parameter in Pentaho

In a Job I am checking if the file that I want to read is available or not. If this csv exists I want to read the data and save them in a database table within a transformation.

This is what I have done so far: 1) I have create the job, 2) I have implemented some parameters, one of them with the path for the file, 3) I have indicated that I am going to pass this value to the transformation.

enter image description here

Now, the thing is, I am sure this is should be something very simple to implement, but even when I have follow some blogs, I have not succeeded with this part of the process. I've tried to follow this example:

http://diethardsteiner.blogspot.com.co/2011/03/pentaho-data-integration-scheduling-and.html

My question remains the same. How can I indicate to the transformation that it has to use the parameter that I am given him from the job?

Upvotes: 1

Views: 2379

Answers (1)

bolav
bolav

Reputation: 6998

You just mixed up the columns

  • Parameter should be the name of the parameter in the transformation you are running.
  • Value is the value you are passing.

Since you are passing a variable, and not a constant value you use the ${} syntax to indicate this.

Screenshot of Transformation settings

Upvotes: 2

Related Questions