Deleting rows - LineNumbersForDeletion

We use it when there are rows in the input data that we need to ignore during import.

Syntax:

<LineNumbersForDeletion>
<int>1</int>
</LineNumbersForDeletion>

Note:

• Lines that do not contain data are automatically ignored.
• The original input data file is not changed.

Example:

The import file contains a name unrelated to the import on the first row and the next two rows are skipped until the column names are listed on row 4. In this case, it is enough to delete row 1 using the function and the other two will be ignored and the data will be loaded. If we were to delete the first three rows (which seems logical at first glance) the command will delete the first row of the title, ignore the two empty rows and then delete the remaining two rows with the already required content and the data will not be loaded.

Input data

After modification