Forcefully assigning course to every users

[MB_Rocks]

Dear All,

Hope you all are doing good!

Here I'm seeking one solution for a problem. I have a user's base and course information. I needed to assign each user the 10 courses.

Here I have attached a file which has three tabs.

Kindly help m

Users

Courses 

Final output

[Yoshiro_Fujimori · Accepted solution]

@MB_Rocks ,

I guess it is a typical usage of Append Field tool.

Please see the attachment.

See also: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Append-Fields/ta-p/874...

[ShankerV · Accepted solution]

Hi @MB_Rocks 

The best way to achieve this with the help of Append Fields tool.

It does a Cartesian joint.

Note: If you input contains more than 16 records (rows) then please modify the below to Allow All Appends to avoid the error when running the workflow.

Many thanks

Shanker V

[Qiu · Accepted solution]

@MB_Rocks 
We use an Append tool maybe then filter out number larger than 10.