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.
Solved! Go to Solution.
@jogu
Can you update the data file we can try something?
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
@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
Hi AZuc,
Thank you, it is now marked as solution.
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.