Tool assignment loop in excel table

[jogu]

Hi, I would like to ask if there is a way to loop in to rows in a table in excel like assigning data ..., below is my scenario.

Assembly Table below has a blank column for tools, there is need to assign tools for the items based on Cat Code.

The desired out is to assign Tools for the Items in the Assembly table. Notice that there are only 3 rows in each Cat tables (above), tools were assigned per row and once all the rows are already assigned the tool will loop to the top and assign the first row in the Cat table.

Thank you in advance for helping resolving this problem.

[Qiu]

@jogu 
Can you update the data file we can try something?

[jogu]

Hi @Qiu please see attached file

[AZuc · Accepted solution]

@jogu , see if it works

[jogu]

Hi AZuc,

I encountered an error when I ran the workflow, I am new in Alteryx that is why I don't know what is happening, may I request a walkthrough regarding the flow.

thank you

[AZuc]

@jogu this error is simple to fix. Check the data types of "Cat Code" in both inputs, I believe 1 of them is numeric and the other is string. Add a Select Tool before the input that has Cat Code as numeric and change data type to V_String

[jogu]

Hi AZuc,

Thank you, it is now marked as solution.

[jogu]

Hi AZuc,

Just want to add one more question, is there a way to know what is the last row assigned in the Cat tables, so that if I will run the tool again for the next batch of Assemblies, it will start on the next row of the last assigned row of tools, not start on the first row.

Thanks again.