Load the copay_claim_pharmacy table from attached mapping sheet

Requirement: 

Create a Pyspark script for the attached source_target_mapping_sheet and populate the target table(“copay_claim_pharmacy“) with its logic.[^source_target_mapping_sheet.xlsx] 

Note: 

if the Source table and Source column is Not Available/ Null / Empty - Refer the logic. 

for obsolete - ignore the obsolete part in the logic. 

Expected Output:

 Display the results