Skip to main content
Question

how to compare two files and identify duplicate values ?

  • January 6, 2021
  • 1 reply
  • 103 views

tomjerry.vl
Forum|alt.badge.img

having "A" and "B" two files compare and identified in both files unique values

1 reply

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • January 6, 2021

There are so many ways to do this. 😏

Maybe the simplest, if you don't care for your output, is to use DuplicateFilter.

If your files are iterations of the same thing you can use ChangeDetector.

If you want to know which value came from which file you can use FeatureMerger where Merged and UsedSupplier are the "duplicate values", and, UnmergedRequestor and UnusedSuplier are the "unique values".

For better speed you can use FeatureJoiner almost the same way as the FeatureMerger.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings