Forcefully assigning course to every users

Question

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

Example.xlsx

Yoshiro_Fujimori · Accepted Answer

@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/87489

ShankerV · Accepted Answer

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 Answer

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