Multi-Row Formula Tool

Question

Hi!

I can't seem to configure the Multi-Row Formula tool correctly for what I want to do.

I have a data set that features Office numbers.   In the data set, I have some values that have a split office # with a "/" in the cell. I used the "Text to Columns" tool to split out the office # into separate columns.

Now I am trying to create a new row for the Office # I split out, using the original values for the remaining columns.

Current data set after "Text to Column Tool":

Office #RegionDigitsNameOffice #1Office #280

South0-9

Bill Blank80 20/86Southeast0-4Joe Smith208688West0-9Nancy Doe88

Goal:

Office #RegionDigitsNameOffice #1Office #280

South0-9

Bill Blank80 20/86Southeast0-4Joe Smith208686Southeast0-4Joe Smith  88West0-9Nancy Doe88

Would someone be able to help me configure the Multi-Row Formula tool to accommodate this?

ChrisTX · Accepted Answer

In your Text to Column tool, can you choose the option to Split to Rows instead of Columns?

The difference is the original row would have Office # "20", not "20/86".

Chris

Bren_Spill2 · Accepted Answer

Hi @RCern - you can use Text to Columns for this, see below. As @ChrisTX mentioned, original row would be just 20, and new row would contain 20 and 86 in Office #1 and Office #2 respectively

ChrisTX · Accepted Answer

Check out the Generate Rows tool, starting with the example inside Alteryx