Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Rinearb
7 - Meteor

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...

IDQuestions
1When
2Why
3How

 

 

 

I want the outcome to have 9 IDs, 9 Questions.

IDQuestions
1When
1Why
1How
2When
2Why
2How
3When
3Why
3How
6 REPLIES 6
r_manju02
8 - Asteroid

Hi,

 

Use the Append Fields tool (refer attachement).

atcodedog05
22 - Nova
22 - Nova

Hi @Rinearb 

 

You can use append tool. Append tool creates combination from each columns.

 

atcodedog05_0-1643381310908.png

 

Learn more about it here : https://help.alteryx.com/20213/designer/append-fields-tool

 

Hope this helps : )

 

Rinearb
7 - Meteor

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

Rinearb
7 - Meteor

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

atcodedog05
22 - Nova
22 - Nova

Hi @Rinearb 

 

It would be similar 

 

atcodedog05_0-1643382087422.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Rinearb 

Cheers and have a nice day!

Labels