Table of contents
TOC
Collapse the table of content
Expand the table of content

Table.ColumnCount

Owen Duncan|Last Updated: 10/5/2018
|
1 Contributor

About

Returns the number of columns in a table.

Table.ColumnCount(table as table) as number  

Arguments

ArgumentDescription
tableThe Table to check.

Example

let  
  
    emptyTable = Table.FromRows({}),  
  
    tableValue = Table.FromRows({{1,"Bob", "123-4567"}, {2,"Jim", "987-6543"}}, {"ProductID", "ProductName", "UnitPrice"})  
  
in  
  
[  
  
    IsEmptyTest1    = Table.IsEmpty(emptyTable),  
  
    IsEmptyTest2 = Table.IsEmpty(tableValue),  
  
    RowCount = Table.RowCount(tableValue),  
  
    ColumnCount = Table.ColumnCount(tableValue)  
  
]  
  
equals  
IsEmptyTest1true
IsEmptyTest2false
RowCount2
ColumnCount3
© 2018 Microsoft