This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Find answers, ask questions, and share expertise about Alteryx Designer.
General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!
Hi, I just had a quick question about using Alteryx to do something I can do in Access relatively easy, but I can't find a solution. If I have a list of customers and a list of SKUs and I want to blend this data together to get every possible combination how would I get Alteryx to do that?
Historically I would just setup a query without a join in Access and then run that query and transform it back into a table to use as the source of my dataset.
Try the Append tool (in the Join category of tools)! It will append everything from your Source data to the Target data, creating all possible combinations. If you have more than 16 SKU's (or customers, depending which list you're using as your Source), you'll need to turn off the default Warn/Error at the bottom of the configuration that prevents it from appending more than 16 records. 🙂