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.

StarSchemaDesign.yxmd

SourceData.txt.txt

SourceData.xlsx

In Database

In-Database

Accepted answers

BrandonB

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/18353

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.

All comments

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 :

city state.png

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

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335