Databases Reference
In-Depth Information
and size is price per square foot - a column that does not exist in the dataset.
Let's add it.
In the Control Center, right-click on the CmpltHomes.csv dataset. Select
the option “Create Derived Set”.
Enter a name of “HomeCosts”.
Click “Select All” to include all current columns in the new dataset.
In the “Computed Columns” box, select “New”.
The “New Column Definition” form that opens (Figure 3.4) allows you to define
a new column based on values in existing columns. You provide the formula.
In the “Available Columns” list box, click “price”.
In the “Operators” list box, click the division operator “/”.
In the “Available Columns” list box, click “sqFeet”.
Enter a name of “pricePerSqFt”.
Select “Create”, to add the column to the new dataset.
Select “Create”, to build the newly derived dataset.
Figure 3.4
New Column Definition Form
