3

I've got this steps

enter image description here

The merge rows diff is configured as follow

enter image description here

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

enter image description here

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.

mariowise
  • 2,167
  • 2
  • 21
  • 34

1 Answers1

3

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:

enter image description here

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

enter image description here

mariowise
  • 2,167
  • 2
  • 21
  • 34
  • 3
    yes, that's it. The keys are the fields to compare records to determine which ones are new or deleted; the values are the fields to compare to determine which ones are identical or changed. The structure of both input streams must mathc (same field names, same data types) – nsousa Jul 28 '14 at 08:41
  • God bless you all three you, your friend and @nsousa thank you! – cumanacr Oct 24 '20 at 03:23