Count if Different Input

[ramkrau]

Today is Day #1 of using Alteryx, so I have no clue what I'm doing... any help is appreciated!

I have two datasets that contain different item numbers, but both contain category information. I need to figure out how to get a column added to my first dataset that tells me how many times my category from dataset 1 is found in dataset 2. How can I get this to work out? A simplified workflow is attached that should represent my problem pretty accurately.

In excel, I'd just use a COUNTIF function and reference the separate workbook column, but I can't figure this out in alteryx.

[Felipe_Ribeir0]

Hi @ramkrau 

your excel input must be attached.

[ramkrau]

Oops! I thought they would be included in the alteryx workflow package.

[Luke_C]

Hi @ramkrau 

A summarize tool with a count function followed by a join should get you what you want:

[binuacs]

@ramkrau One way of doing this