Alteryx Designer Discussions

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!

SOLVED

Select Over Multiple Tables

jmarleigh
7 - Meteor

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.

 

The SQL would look like the below.

 

SELECT SKUs.SKUs, Stores.Stores
FROM SKUs, SKUs;

 

Thanks,

Justin

NicoleJohnson
14 - Magnetar
14 - Magnetar

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

 

Hope that helps!

 

NJ

jmarleigh
7 - Meteor

Exactly what I was looking for!

 

Thank you so much

Labels