REMOVE_IN_TABLE FORMULA (element, string or list)

This formula is designed to completely remove rows or columns from a table-type field.

The item parameter accepts two possible options: rows and columns. Please, note that a syntax error in the formula definition will occur unless using one of these options.

This is the type of item to be removed from the table type field.

The second argument accepts a comma-separated list of row or column names as items to remove. In the case of columns, the title of those columns to be removed will be searched in the first row of the table field content. In the same way, these titles will be searched in the cells of the first column (the one on the left), in case you want to eliminate row-type elements.

This formula can be used both in import connectors and bulk modification actions.

Some examples of operations are shown below.

1.1. ORIGIN:

REMOVE_FROM_TABLE(“columns”, [“Value”, “Modified”])

1.2. RESULT:

2.1. ORIGIN:

REMOVE_FROM_TABLE(“rows”, [“Voltage (V)”])

2.2. RESULT: