Copy and Paste in the same field through looping

[rouzu]

Greeting, Please help me how to copy the row field like this in alteryx, which I want to copy and paste are the value from the class A until E to Lily, John , Sonny, Robert and Eve, also the row Jack until Sora. Which tool are used?

Name Class

Adam      A
carl         B
Hans      C
Alli          D
Kahm     E
Lily
John
Sonny
Robert
Eve
Jack
Sam
Katty
Nahm
Sora

[JoshKushner · Accepted solution]

You'll want to use the multi-row tool to assign letters based on the previous row.

I've attached a sample workflow.

Flow:

Results:

Multi-Row Tool:

[rouzu · Accepted solution]

Thank you for your reply, really appreciate.

[vishwa_0308 · Accepted solution]

Hi @rouzu,

This is my version of solution for your query as You want to fill all you remaining "Class" field with A to E. I have used Multi-row formula and changed the Num Rows to 5 to traverse upto 5 letters(A,B,C,D,E) only.

Note: I have already given A to E to first 5 names as per your given inputs after then this will assign A to E to all the names as per the solution.

Best,

Vishwa

[rouzu · Accepted solution]

This also works for me, really appreciate this technique. Thank..