partitioned

partitioned, contextual keyword

The partitioned keyword changes a write block so it emits multiple files, one per distinct path.

Example

table Products = with
  [| as Product, as Color, as Price |]
  [| "shirt", "white", 10.50 |]
  [| "pants", "blue", 15.00 |]
  [| "hat", "white", 5.25 |]

Products.Path = "/products-\{Products.Color}.csv"

write Products partitioned as Products.Path with
  Product = Products.Product
  Color = Products.Color
  Price = Products.Price

This produces two files: /products-white.csv and /products-blue.csv.

Remarks

The maximum number of files produced by a single write ... partitioned block is 100. Exceeding that limit fails at runtime.

See also

• write