Replace Columns Value With Mapping File (Mapping File Should be in Workflow Data Folder)

This component replace the value of each column (multiple) with the value from mapping file.

Note:
1. Mapping file should be an Excel File.
2. Each sheet of Excel File will contain the mapping of each column.
3. Each sheet name will be exactly same as the column it is mapping in the table.
4. There should be only two columns in each sheet (1. First column will be having data that is coming from the table. 2. Second column should have the data that should be replaced with)
5. The name of the first column can be anything but should same in each sheet.
5. Second column name should be as same as the sheet name and the name of the column that is mapped.

IMPORTANT: To make this component work in any environment this component will read the mapping Excel from the workflow data area.

Input ports

1. Type: Table
   Port 1
   1. Input Data Table
   
2. Type: Table
   Port 2
   Configurations Table
   a. String Column containing the path of mapping folder (Workflow data area).
   b. String: Column Containing the column name of Input Data which is same in each sheet.
   c. String: Column containing the column name of the Input Data Table that is the primary key.

Output ports

1. Type: Table
   Port 1
   Data Output