Set Properties in Pentaho

In this blog, we will learn how to set properties in Pentaho. Please do follow the below steps:

1. What we need is a Transformation at the Beginning of our Job
2. Make a new .txt file, rename it to anyname.properties (In my Case LoopPropertyFile.properties)
3. Within our transformation, we require 2 components
• Property Input
• Modified JavaScript



4. Within the property Input, we give the path of our new Property File and then click add and you will get the path in the Selected Fields.



you can preview rows to see the values from your Property File

5. Go to the Fields tab, and Selected get Fields



Select OK

6. Go to the Modified JavaScript and add the below code.

   setVariable(Key,Value,"r");

   Select Ok and Save and now in your property File, as shown on mine,

   
   we can call ${init} variable.

Best Open Source Business Intelligence Software Helical Insight is Here

A Business Intelligence Framework

Free
Download

In Case if you have any queries please get us at support@helicaltech.com

Thanks
Sohail Izebhijie
Helical IT Solutions Pvt Ltd