How to Change the date format yyyy/MM/dd HH:mm:ss to dd_mm_yy through modified java script value in pentaho

pentaho kettle pentaho-spoon
Ms13 picture Ms13 · May 12, 2016 · Viewed 9.2k times · Source

How to Change the date format yyyy/MM/dd HH:mm:ss to dd_mm_yy through modified java script value in pentaho?

Answer

mzy picture mzy · May 13, 2016

Use this function in Modified Java Script Value step:

date2str(input, "dd_MM_yy");

kettle example

Related questions

Replace null value with NA using Pentaho Kettle

I have an input csv file with one column field value as empty. I want to replace that field value as NA in my destination table. And in my destination table that column is specified as not null column. I …

Read More
Remove special characters using Pentaho - Replace in String

I wanted to remove the special characters like ! @ # $ % ^ * _ = + | \ } { [ ] : ; < > ? / in a string field. I used the "Replace in String" step and enabled the use RegEx. However, I do not know the right syntax that I will put in "Search" …

Read More
Pentaho: How to dynamically add Field (= Column) to OutputRow?

I would like to dynamically add fields (or a new columns) to the resulting output row in Kettle. After spending hours reading through froum posts and he not so well done scripting documentation, I wondered if Stackoverflow would be of …

Read More