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?