Hello.
I have two excel files (1) and (2) that contain a column of addresses.
The "House number" column in the excel file (1) and the "Houseno" column in the excel file (2)
How could I compare the two columns and notice the similarities and differences.
Thank you very much!
You could use a FeatureJoiner or FeatureMerger to join the two files on those two attributes (so house number and street), anything that does not join is a mismatch.
You could use a ChangeDetector to identify the changes. The house number attribute would need to be the same between the files, so I would use an AttributeRenamer to change the name to match the other file, i.e. both named "House number". In the ChangeDetector, the Update Detection Key Attribute would be set to "House number". This should tell you the Adds and Deletes, and if you specify the Check Attributes parameters, it will tell you which have been updated as well.
You could use a FeatureJoiner or FeatureMerger to join the two files on those two attributes (so house number and street), anything that does not join is a mismatch.
Thank you very much😀 The suggested solution works very well!
You could use a ChangeDetector to identify the changes. The house number attribute would need to be the same between the files, so I would use an AttributeRenamer to change the name to match the other file, i.e. both named "House number". In the ChangeDetector, the Update Detection Key Attribute would be set to "House number". This should tell you the Adds and Deletes, and if you specify the Check Attributes parameters, it will tell you which have been updated as well.
I also tried this option. It works great too!
Thanks!
you could also use transformer "DatabaseJoiner" which could results in "Joined" and "Unjoined" records.