How to loop and stack data?

[mprieto200]

Hello,

I want to add a new value in a column for a data set but then change the value of the data and keep stacking. For instance, I have 50 rows and I want to add a new column called state. Now how do I make the 50 rows go through add a state then stack the data. End result should have 50 rows for each state.

[apathetichell]

First way starts with states and adds 50 rows to each state entry.

Second example starts with 50 rows and appends the state database (in this case an abridged form) to the 50 rows. Both cases end up with 50*8 or 400 rows.

[DawnDuong · Accepted solution]

hi @mprieto200 

When you want to have an output that have NxM rows, the first tool to think of is "Append Fields Tool". Highly recommend that you try out the Example: Click on the Tool, then a hyperlink will appear, click on the hyperlink will take you to an example workflow that includes a number of configurations and possible use cases that you can emulate for your next workflows.

Cheers,

Dawn.

[mprieto200]

Thank you! That did the trick!