Summary

Deletes selected rows or parts of rows from the data table.

Configuration

Input settings of existing table

Name

Value

Opt.

Description

Example

Rows to delete

System.Object

-

Enter the required row numbers.

  • 5-10...Delete rows 5 to 10.
  • B1-B10...Delete the last 10 rows.
  • 10-B1...Delete everything after row 10.

-

Settings

Name

Value

Opt.

Description

Example

Show warnings option

System.String

  • All
  • Only if no row was deleted
  • Only if all rows were deleted
  • None

Opt.

Choose option to mark operator with the warning sign

-

Want to learn more?

Screenshot

Examples

Example: Delete rows

Situation

Rows 1-8, 10, and 12 should be deleted from the following table:

Operation setting


Please note:

  • You can define independent sets of rows, e.g., 1-50, 500-520 ... rows 1 to 50, rows 500 to 520 are deleted.
  • You can define the last rows, e.g., B1-B50, B500-B520 ... deletes the last 50 rows and rows 500 to 520 counted from the end of the table.
  • You can mix both definitions, e.g., 2-B2 ... deletes everything except the first and last row.

Result

TIS Project

-


Troubleshooting

Problem

Frequent cause

Solution

The wrong rows have been deleted.

Typing errors...

Check spelling

How do I find the data set causing the error?


a) Search for a certain term.

b) If this is not possible, try binary search:

  • delete the first half of the data sets (rows)
  • if the error is still there, it must be in the second half
  • if not, the error must be in the first half, and so on.

How do I delete the last data sets?


Elegant work-around:

Related topics