Pentaho merge rows (diff) not showing "changed"

Question

I've got this steps

The merge rows diff is configured as follow

But when a update is detected it doesn't show the "changed" tag, it show two rows, a deleted and a new

The documentation says that a "changed" tag should be displayed on the update case. Could anybody help me on this?

I've try with the sort by id steps, and I currently have a SORT BY id on the table imput query. But nothing seems to work.

Answer 1

Well, a friend saw the problem. The key fields and the value fields definition was all wrong. This is the right way to configure the merge row (diff) step:

The `Get value fields' button confuses me. Now I've got the right result