Multi-Row Formula Tool
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 # | Region | Digits | Name | Office #1 | Office #2 |
80 | South | 0-9 | Bill Blank | 80 | |
20/86 | Southeast | 0-4 | Joe Smith | 20 | 86 |
88 | West | 0-9 | Nancy Doe | 88 |
Goal:
Office # | Region | Digits | Name | Office #1 | Office #2 |
80 | South | 0-9 | Bill Blank | 80 | |
20/86 | Southeast | 0-4 | Joe Smith | 20 | 86 |
86 | Southeast | 0-4 | Joe Smith | ||
88 | West | 0-9 | Nancy Doe | 88 |
Would someone be able to help me configure the Multi-Row Formula tool to accommodate this?
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@RCern - please see attached workflow.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ChrisTX Thank you! Now how would I go about creating new Office #'s based on the "Digit" range.
For example, using the data in my original post above, Office # 80 has a "Digit" range of "0-9". How do I duplicate sales office # 80's data but create a new office # that includes a digit.
For example:
800
801
802
803
804
805
806
807
808
809
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Check out the Generate Rows tool, starting with the example inside Alteryx