Bulk load of excel sheet with empty worksheet

@MarekV if you take a look at this example with your files the empty entry is being skipped.

You can configure what the reader would consider as a missing entry and skip it if you want.

If you still have duplicates you can further elevate them with the Duplicate Row Filter or advanced techniques.

kn_forum_43934_excel_bulk_import.knwf (51.2 KB)

3 Likes