Table.RemoveRows
  • 08 Aug 2024
  • 1 Minute to read
  • Dark
    Light

Table.RemoveRows

  • Dark
    Light

Article summary

General

The Table.RemoveRows can be used in the Post Processor property of a table Element to remove rows that contain cells of the given type.

DataTopHeader = 0
TotalsTopHeader = 1
SubTotalsTopHeader = 2
DataLeftHeader = 3
TotalsLeftHeader = 4
SubTotalsLeftHeader = 5
Data = 6
Total = 7
SubTotal = 8
Filler = 9

Syntax

The syntax of the Table.RemoveRows function is:

Table.RemoveRows Function Syntax

Table.RemoveRows(<cell type>)

Examples

All TotalsLeftHeader rows will be removed:

Substring Function Example

Table.RemoveRows(4)


Was this article helpful?

What's Next