Implement Product-Therapeutic Area Join Logic in patient_study table

Introduction: To map the product in the patient_study table with the therapeutic_area_mapping table. So we can populate the corresponding therapeutic_area column in patient_study for downstream therapeutic-level insights and segmentation.

 

Requirements: Create the sql logic by Read the table ‘purgo_playground.study' and create the table 'purgo_playground.patient_study’ according to data_mapping sheet attached and update the logic in the patient_study table, add the therapeutic_area column based on product map with therapeutic_area_mapping table. For unmatched product, populate therapeutic_area as NULL.

 

Final output: Display the patient_study table.

 

Unity Catalog: ‘purgo_playground.study', ‘purgo_playground.therapeutic_area_mapping’