Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

Joins for a star schema

Highlighted
6 - Meteoroid

Hello,

I have a fact table - Transactions - that has the foreign key of 3 dimension tables customer, product, store. The  workflow should provide dimensional attributes of tables customer, product, store along with transaction date and quantity from Transactions table. Therefore, the Transactions table should be joined with the 3 dimension tables. Is a 3 step join ( Join 1 : Customers + Transactions -> Join 2 : + Product ->Join 3: + Store) the only option or is there a shorter method to achieve the same in Designer?

Thanks

:Rajiv

 

 

Alteryx
Alteryx

Hello Rajiv,

 

Using multiple joins is the method I would use to complete this within Alteryx Designer.  The alternative is that you complete the joins at in the Visual Query builder / SQL statement before bringing the data into the designer.  

 

Thanks,

Nick

Highlighted
6 - Meteoroid

Thanks @NickC

Labels