Here are 2 issues I’m seeing with Import Table Data.
My source is an Excel spreadsheet (.xlsx). The spreadsheet has 3 rows, first row is header. I specify First Row 2, Last Row 3. On the Preview File and Define Fields screen, I only see row 2 from the spreadsheet, I should see row 2 and row 3. (See attached image).
On the Specify Import Mode screen, I set commit mode to “One commit after all records”, however, if the import fails, it commits whatever records made it prior to the failure. The behaviour appears to be that even though I chose commit mode “One commit after all records”, its defaulting to “Commit after each record”.