Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics 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

 

 

Highlighted
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