I want to generate a date dynamically based on row numbers using pentaho pdi
.
for example:
row 1 =====>Date=2015-06-08 **01**:56:30
row 2 =====>Date=2015-06-08 **02**:56:30
row 3 =====>Date=2015-06-08 **03**:56:30
row 4 =====>Date=2015-06-08 **04**:56:30
All my data come from an excel spreadsheet with row number and date fields and I want the date to change dynamically.
Easily done. Use an
Add sequence
step to generate the row ID. Then theCalculator
step has a formula called 'Date A + B Hours'. It looks like this:I hard coded the base date in the
Generate Rows
step.