Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Joins for a star schema

rajiv
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

 

 

2 REPLIES 2
NickC
Alteryx Alumni (Retired)

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

rajiv
6 - Meteoroid

Thanks @NickC

Labels