Is this even possible in Alteryx

[DonnaFazio]

I am trying to identify missing products by item per territory. I know I can count them. But is it possible to get a lay like this in Alteryx?

[Emil_Kos]

Hi,

I am not sure what do you want to achieve. In the file that you have provided there is one list and I have splited it.

I don't see anything missing in first or the second group and I identified it by using join tool.

If something would be missing it would be present in the left or right anchor. 

If this was helpful please mark my post as a solution!

[DonnaFazio]

Thanks for the reply. The example was my desired results based on the attached data sheet as an example

[Ben_H]

Hi @DonnaFazio,

I think this is what you were after - I've generated a full list of possible combinations of the Name and ProductGroupNumber fields, and then joined that to actual list. The records that do not match to the full list should be your missing products.

Hopefully that helps, and is indeed what you wanted.

Regards,

Ben

[DonnaFazio]

OH MY GOSH!!! Should have come here days ago... THANK YOU SO MUCH!!!!