This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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.