Populate Inventory Transaction table using Data Mapping xls

Introduction: An inventory transaction refers to any change in the status or quantity of items within a supply chain management system. This offers the recording of inbound inventory when raw materials, components, or finished goods are received from suppliers. There are several KPIs that depend on data from the inventory transaction table.

 

Requirement: Develop Databricks SQL logic to display all the fields based on the field mappings provided in the attached Excel file. The Excel file contains a detailed mapping of each field in the target table in Data_Map sheet , sourced from multiple corresponding source tables in Source_Tables sheet and the join conditions in Joins sheets