How to use a count records variable to perfectly repeat a record x number of times
- 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
Can someone help me understand how to set the expressions in a generate numbered rows function to have a Count Records variable. I was thinking something like [ID] * [Count of Questions] so that each ID has 1 question repeated.
For instance, if I have 3 IDs and 3 Questions...
ID | Questions |
1 | When |
2 | Why |
3 | How |
I want the outcome to have 9 IDs, 9 Questions.
ID | Questions |
1 | When |
1 | Why |
1 | How |
2 | When |
2 | Why |
2 | How |
3 | When |
3 | Why |
3 | How |
Solved! Go to Solution.
- Labels:
- Expression
- 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
Hi @Rinearb
You can use append tool. Append tool creates combination from each columns.
Learn more about it here : https://help.alteryx.com/20213/designer/append-fields-tool
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I know this wasn't in-depth but what if ID and Questions were two different Input Tables
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nevermind Found the solution to the in-depth part using the appending fields function. Thanks
- 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
Happy to help : ) @Rinearb
Cheers and have a nice day!