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

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

Expression

Accepted answers

r_manju02

Hi,

Use the Append Fields tool (refer attachement).

Questions.yxmd

atcodedog05

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 : )

All comments

r_manju02

Hi,

Use the Append Fields tool (refer attachement).

Questions.yxmd

atcodedog05

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

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335