Joins for a star schema

Question

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 Answer

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