Thursday, May 13, 2010

Date to String Conversion in Pentaho Kettle

0 comments
Here is the simple conversion from Date to String in the spoon
Go the design mode select Modified Java Script Step lying under the Scripting folder drag & drop it.
image
Double click the Java Modified Script  Step and write the following code in the scriptVale
var dateToStringConversion = date2str(datefield_name, "yyyyMMdd");
where dateToStringConversion  is the name of the variable and datefield_name is the field name to whom you want to convert which is coming from the previous step

0 comments: