Alteryx Designer Desktop Discussions

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

Select Over Multiple Tables

jmarleigh
Meteoro

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

2 RESPUESTAS 2
NicoleJohnson
ACE Emeritus
ACE Emeritus

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
Meteoro

Exactly what I was looking for!

 

Thank you so much

Encuestas
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Etiquetas