I’m trying to create test data for a star schema with a fact table of visit and dimension tables for office, nurse and patient. I have a list of offices already in a dataset, but I need to make sure that when I tie everything together the office, nurse and patient are all in the same US state (GA, FL etc). I’ve tried a few things but am not finding a way to do this. Any help would be appreciated.
I solved my own problem by linking everything back to my location table with a two character state code. I used
from_dataset(“location”,“location_id”,state: state2) to look up the right location_id for each of the other tables.