Joins for a star schema

[rajiv]

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

[NickC · Accepted solution]

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]

Thanks @NickC