Table Difference Finder gives huge and rather useless differences

Hello @bruno29a and thanks for bringing me back to the topic.
Maybe I didn’t realized on #feature-reques tag at that time, so I just double fall into the fact that some previous work ‘can be done’ (i said), ‘is required’ @Thiemo.Kellner said…

Just prepared an example for this post showing that: without some data preparation work, the result is just hard to use. In the example, the compare table has just two differences: 1 content + 1 missed row.


20230317_table_difference_data_preparation_v0.knwf (95.3 KB)

Without ID arrangement:

  • upper ‘Table Difference Finder’, without fill in gaps and pair IDs returns an useless output, messing the IDs.
  • lower ‘Table Difference Finder’ in the other hand is returning a row for each difference, useful output.

Then, decidedly and as @bruno29a said and about select a field/column to track differences in this node…

BR

1 Like