Start Free Trial

Alteryx Designer Desktop Discussions

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

Populate boolean if two table values exist in another table

TeslaBoy
5 - Atom

I know this must be something simple but a little stumped at the moment.

 

I have 2 tables. Table1 has a bunch of users and their colors. The colors are repeated for each user, so all users have 3 rows. This table was built from a workflow I built.

 

Table2 is a record of which colors each user has, so the row count for each user is different. This is an imported data source (csv).

 

I want to populate a third column in Table1 that will be a boolean showing if that user has that color.

 

I've been Googling for a solution and I can't seem to put it together. In Excel this would be pretty straightforward, just a COUNTIFS, so I'm guessing it's something simple. Thanks for any help!!

 

boolean.PNG

2 REPLIES 2
KrishnaChithrathil
11 - Bolide

@TeslaBoy 

How about this? I hope this is what you're looking for.

Input-1 

Table - A

KrishnaChithrathil_0-1669975400875.png

 

Input - 2

Table - B

KrishnaChithrathil_1-1669975439800.png

 

 

Output

KrishnaChithrathil_3-1669973089543.png

KrishnaChithrathil_2-1669975482377.png

 

 

binuacs
21 - Polaris

@TeslaBoy Similar to @KrishnaChithrathil method

binuacs_0-1670020254788.png

 

Labels
Top Solution Authors