You can programmatically access the actual name of the source Excel worksheet and use it as a field value in the destination.
If you are extracting data from an Excel file and loading it into a database while accessing the worksheet by using a 1-based index (not by name), you still might want to use the actual source worksheet name as a value for one of the fields in the destination table.
Step 1. Create a Mapping for when the source field doesn't exist, and the destination field is a calculated field.
Step 2. Click the
Edit field value function (pen) icon and enter the following line:
Please sign in to leave a comment.