table

table, keyword

The table keyword indicates that the statement reflects the creation of a table.

table T = extend.range(10)
show table "My Range" a1a8 with T.N

There are multiple ways to create a table from another table, such as the by statement.

table T = extend.range(10)
table U[u] = by T.N mod 4
show table "My Range" a1a8 with u

Or the where statement:

table T = extend.range(10)
table U = where T.N < 5
U.N = T.N
show table "My Range" a1a8 with U.N

table, tile type

The table tile is the most versatile tile offered by Envision. This tile is intended to display a table, and this table can optionally be exported as a flat file.

table T = with
  [| as Product, as Price, as StartDate      |]
  [| "Hat"     , 42.25   , date(2022, 1, 1)  |]
  [| "Pant"    , 59.95   , date(2022, 1, 1)  |]
  [| "Shoe"    , 49.90   , date(2022, 2, 17) |]

show table "Products" a1c3 with
  T.Product
  T.Price
  T.StartDate

The tile can be sorted with the order by option.

table T = with
  [| as Product, as Price, as StartDate      |]
  [| "Hat"     , 42.25   , date(2022, 1, 1)  |]
  [| "Pant"    , 59.95   , date(2022, 1, 1)  |]
  [| "Shoe"    , 49.90   , date(2022, 2, 17) |]

show table "Products" a1c3 with
  T.Product
  T.Price
  T.StartDate
  order by T.Price desc

The tile can internally perform an aggregation with the group by option.

table T = with
  [| as Product, as Price, as StartDate      |]
  [| "Hat"     , 42.25   , date(2022, 1, 1)  |]
  [| "Pant"    , 59.95   , date(2022, 1, 6)  |]
  [| "Shoe"    , 49.90   , date(2022, 2, 17) |]

show table "Products" a1c3 with
  count(T.*) as "Launched"
  T.StartDate
  group by T.StartDate

Tile-level options

The table tile supports options defined at the tile-level.

table T = with
  [| as Product, as Price, as StartDate      |]
  [| "Hat"     , 42.25   , date(2022, 1, 1)  |]
  [| "Pant"    , 59.95   , date(2022, 1, 1)  |]
  [| "Shoe"    , 49.90   , date(2022, 2, 17) |]

show table "Products" a1c3  date: "MM-dd-yyyy" write:"/sample/products.csv" with
  T.Product
  T.Price
  T.StartDate

The list of options available are:

Column-level options

The table tile supports options defined at the column-level.

table T = with
  [| as Product, as Price, as StartDate      |]
  [| "Hat"     , 42.25   , date(2022, 1, 1)  |]
  [| "Pant"    , 59.95   , date(2022, 1, 1)  |]
  [| "Shoe"    , 49.90   , date(2022, 2, 17) |]

show table "Products" a1c3  write:"/sample/products.csv" with
  T.Product
  T.Price
  T.StartDate write:false

The list of options at the column level are: