This is incredible. Thank you so much for taking the time to help, @bobbyragsdale ! I'm going to start looking into this.

Unfortunately, there isn't a single common identifier in any the source systems to use for a common join. Let's take this example: Golden Record Customer Name: Coca Cola Customer Address: 123 Coke Lane, North Pole, H0H 0H0 Records From Other Systems Record 1 Customer Name: Coca-Cola Record 1 Customer Address: 123 Coke Ln,…