How to loop and stack data?

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.

Workflow

Accepted answers

DawnDuong

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.

All comments

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.

50 states in two ways.yxmd

DawnDuong

hi @mprieto200

Cheers,

Dawn.

mprieto200

Thank you! That did the trick!

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177