Dynamic Data insert using knime

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)

I was able to resolve the issue. In the Table Creator, I’ve set up three columns: ExcelName, TableName, and SPName. Each Excel file in the folder has a corresponding table name and stored procedure name listed.

When I run the workflow with three Excel files, it processes correctly. However, when I include a fourth Excel file, it processes the first one but then tries to reprocess it in the loop, resulting in an error. Will the workflow process the files based on the order specified in the Table Creator?