community
cancel
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)

Highlighted
Meteor

Hi, 

 

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

Labels