Generate Calculated Fields in profile_case table Using Excel Sheet

Requirement: Refer to the attached Excel sheet to create the additional columns for the profile_case table using Databricks SQL, apart from the existing ones.

 

 

 

Prerequisite:

 

1. Drop the table profile_case_clone if exist.
2. Create replica of profile_case table in profile_case_clone table and perform the requirement in the replica table.