Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

How to find percentage after joining two tables that didn't join (left over inner)




I have joined two tables my left is the main one and then there's my right. after i inner joined the two how do i use alteryx to tell me what % joined from left table vs which % that didn't join from left? 


Easy to do in python but unsure how to use alteryx

Alteryx Certified Partner

Hey @zsharif 


You could do a simple count records out of each part of your join (giving you three counts)....append these together and you have the values you need to calc the percentage