Need help with linking data and inputting information in a table

[MMManji]

Hey Alteryx Community, 

Really hoping you can help expand my *really basic* Alteryx knowledge. 

I have a wf that I'm working on and basically what i need it to do is:

-pull from multiple data sources > align column names as they vary> filter population through rules for "breaks"> create output file with those specific breaks of both data sources> also have a table summarizing breaks/total number for each field. 

I've attached an input file and what i would like the output result to look like. I would really appreciate any help you can offer. 

Thank you all! 

[Qiu]

@MMManji 
I think the tricky part is the "Column Name" as you have mentioned "align column names as they vary>".
Are these names having some naming convention or pattern we can use?
Ex: having postfix or prefix sort of
USA will be the postfix?

House Number

House NumberUSA