The keyword read offers versatile mechanisms to read data from files.
Example:
table Products = with
[| as Product, as Color, as Price |]
[| "shirt", "white,grey", 10.50 |]
[| "pants", "blue", 15.00 |]
[| "hat", "red", 5.25 |]
write Products as "/sample/products.csv" with
Product = Products.Product
Color = Products.Color
Price = Products.Price
Then,
read "/sample/products.csv" as Products with
Product : text
Color : text
Price : number
show table "My Display" a1b3 with
Products.Product
Products.Color
Products.Price