Alteryx Designer :StarSchemaDesign-Populate Facts & Dims

[stevelogue1980]

Hi Geeks,

I am a new bee of Alteryx and trying to Design the below Star Schema and Populate Multiple small Tables like Facts & Dimensions using Alteryx Designer as per below.

Please find the Source File,DML and Alteryx file and help me with Alteryx  designer.

[BrandonB]

@stevelogue1980 if you are looking to find unique combinations of these values, you can use the summarize tool and group by the columns of interest to view all combinations. For example, when we group by City and State, you see all of the City and State Combinations for your data set :

[stevelogue1980]

Not group by, looking to Populate Multiple small Tables with generating ROW IDs for PK, FK relationships,  like a star schema with by joining to a Date DIM/ Date ID

[BrandonB · Accepted solution]

This article covers the creation of creating Primary Keys using Alteryx: https://community.alteryx.com/t5/Alteryx-Designer/Create-Database-Table-Primary-Key-in-Alteryx/ta-p/...

You can use the Alteryx tools to get the data in the format that you want to write up to a table, and then you can use PostSQL within that tool as well.