I am working on a Budget Request report. In previous transformations the people who see this report just wanted to know which rows of data changed (IE it which Budget Requests were updated/changed/etc.) but now they would like to see how they have changed from the previous requests. Essentially, I just want to see the columns in Pentaho be marked if they changed. Is that possible in PDI?
Previously I was using the Merge Rows (diff) step to show the rows that change, how can we do that for columns?
I am not sure what is your exact requirement.
If you want to add a new column which displays a flag that shows if a value is changed then I think you can achieve same from "Modified JavaScript value" step.
or if you want to display a difference then you can use a calculator step...
Thanks
Ravik