Table - Create a new data table

Table, Target table, Source table [, Filter instruction]

The Table function creates a new data table "Target table" on the basis of an already existing data table "Source table" with an optional filter instruction.

An alternative function name is: New

Example 1

from 001 xcf create table 03

A new table "Vehicle" is created as a complete (though unfiltered) copy of the "Vehicles" data table.

Example 2

from 001 xcf create table 04

A new table "Vehicle" is created from the "Vehicles" data table with all vehicles manu­factured since 2020.

Example 3

from 001 xcf create table 05

A new table "Product" is created from the data table "Products" with all Products of the C category. Ultimately, the Product data table then is filtered against itself and now contains only the products:

  • of the C category

  • and with a price from 75.99 to 135.99.