Here is the scenario -
l have a Patient dataset and a Provider dataset. Both datasets are generated from schemas that have a State column. I would like to add a Preferred Provider column to the Patient schema, that populates a provider name from the Provider Dataset - the caveat is instead of being random, I would like to populate the a provider whose state matches the patient state. Is there a way to do this ?