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.
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 : )
I know this wasn't in-depth but what if ID and Questions were two different Input Tables
Nevermind Found the solution to the in-depth part using the appending fields function. Thanks
Happy to help : ) @Rinearb
Cheers and have a nice day!