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!!
How about this? I hope this is what you're looking for.
Input-1
Table - A
Input - 2
Table - B
Output
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |