We’re working with multiple Excel files that have different columns and data formats. Each Excel file corresponds to a specific SQL table for data insertion. However, the
column names in the Excel files don’t match those in the SQL tables. For example, an Excel column might be labeled “Employee,” while the SQL table has “Employee_NO.”
The Excel data starts from row 4, and the actual column names that matches with sql columns are in row 5. When I try to execute the data insertion, I encounter conversion errors.
Is there a way to handle this dynamically?. Attached sample Excel and workflow for reference.
147 Employee_V0.1 - Copy.xlsx (15.9 KB)