Finding contacts with override set but no address

Hello,

I experienced the same behavior as you with the Override checkbox. I attempted to create a GI that will allow you to compare addresses.  In the example, I used Override on the first two addresses, modifying the first and making the second billing address blank as you describe.  For those customers where Override Billing Address is NOT checked… the main address is populated:

To create the above GI, I connected the Address table a second time with a different alias:

Join that I used for Billing Address:

Result is attached. I hope this helps you!

I found your question intriguing and interesting. Thanks!

Laura

I understand what you are doing but it does not match the issue I am looking at.  It’s the contact address that has a blank entry, not the business address.  Since you are linking the address table to the customer, you will get the address record for the customer entity and not the address record for any of the contacts.  Or I misunderstand.