Hey all -
I have two excel sheets where one contains a list of properties and each column shows data specific to each property. So in total, there are 1,000 properties.
I have another excel that contains any person connected to that property and each column would show their contact information and mailing address. So in total there are over 3,700 contacts and match to the 1,000 properties in the other sheet. I don’t have access to the data source but I believe the data is from exporting “any contact info” from a list of 1,000 properties.
So I’m trying to Join the two tables together to match up the property addresses of both spreadsheets. The end result should be 1,000 properties and columns added that show the contact information for each property. So if there are 4 owners for one property, then the end result would show one property and columns for all the owner contact information.
But I’m having trouble creating my workflow. I’ve built formulas into the sheets to concatonate the property information into a full address. Of the 1,000 properties, there are 16 properties that do not a have a perfect full address match, which I believe is because there is not any contact info for these properties. I’m not sure if this is creating an error, but the output of my workflow results in over 61,000 rows of data… most of them are the same property repeated.
Can anyone assist? I’ll link the flow below.