Evaluate a series of IDs within a group and flag when any of the IDs Repeats.

[JPSeagull]

I am trying to resolve a challenge given me.

I have a series of Tasks with lines tracking actions on kits that are used which is straightforward. However, when within the same Task ID, we want to know if any of the Kits are repeated. That is, if the kits used are cycled through and then one used earlier in the series is brought back, we need to flag that. What compounds this we have NULLs which I can filter out. 

I tried to use the Multi-row formula, but I get the error that the Kit ID is an unknown variable.

In the end, I am trying to build out a summary view like below either in Alteryx or take the pre-summarized data over to Tableau to do this.

Task ID	Total Entries	Kit Repeated after Break?
1001	5	Yes
1002	4	No
1003	8	No
1004	9	Yes
1005	11	No
1006	4	No
1007	14	Yes

[JPSeagull]

@gabrielvilella Yes, I realized my input data had leading and trailing spaces as well.

Thank you for the workflow. It helps advance towards a solution, but I am not there yet. I am hoping to indicate 

Task ID	Entry ID	Kit ID	Kit Repeated between Kit(s)?
1001	1	93	No
1001	2	93	No
1001	3	241	No
1001	4	241	No
1001	5	93	Yes

[gabrielvilella · Accepted solution]

Thank you for this explanation. I understand now what you are trying to do. Please see if this is it.

[JPSeagull]

@gabrielvilella your solution is GENIUS!  I cannot thank you enough as I spent a week working this in Tableau and finally a colleague insisted I try it in Alteryx. I hope to eventually learn how to do this myself.

Thank you so very much!

[gabrielvilella]

Happy to help @JPSeagull :)