How to use a count records variable to perfectly repeat a record x number of times

[Rinearb]

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

[r_manju02 · Accepted solution]

Hi,

Use the Append Fields tool (refer attachement).

[atcodedog05 · Accepted 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 : )

[Rinearb]

I know this wasn't in-depth but what if ID and Questions were two different Input Tables

[Rinearb]

Nevermind Found the solution to the in-depth part using the appending fields function. Thanks

[atcodedog05]

Hi @Rinearb 

It would be similar 

Hope this helps : )

[atcodedog05]

Happy to help : ) @Rinearb 

Cheers and have a nice day!