Unique ID Pattern
- 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
I have survey data that looks like this and I want to append a uniqueid (1-3) every 3 rows of the name:
|
| ||
|
| ||
|
| ||
|
| ||
|
| ||
|
|
My output should look like this:
RecordID | Name | Response |
1 | Afammy | Yes |
2 | Afammy | No |
3 | Afammy | Maybe |
1 | JoeShmoe | Who Knows |
2 | JoeShmoe | Its possible |
3 | JoeShmoe | Why not |
RecordID tool not helpful here, can't seem to find a formula, and regex looks for patterns but in the data. I think this is a simple enough task but confounded at the moment- maybe been at it too long! Thanks for any help you can offer.
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use the 'Multi-row formula' tool- your formula would check the row above to see if it is null or 3 and if so, enter a 1, otherwise +1 from the value above.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The tile tool will do this if you set the tile method to "unique value" and the unique field to the respondants name. You can also use the multi row formula tool as well.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Afammy I'm late to the party but I would use a mod formula like this one:
MODULO([RecordID], 3)+1
You could either use use a RecordID tool followed by a formula or a Multi-Row formula.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks all,the multi tool would have worked also. I chose the Tile tool because I hadn't used it yet and seemed like the easiest option- now I've added another tool to my tool box. Can't say enough about the expertise and responsiveness of this community. Much appreciated!
