price, from the data table and creates a new data table using the
tablefunction at the end of the method chain.
selectmethod chain. In order to set these attributes, reference an individual column using the
columnmethod and then use any number of the column attribute methods to set it's values.
asfunction to change the name of a field. In the example below, the field
quantitywill be named
number_of_skusin the new table.
titlefunction to give any column a descriptive title. This will be set into the
Titleproperty for the column in the resulting table.
Titlevalue for any column. If one is not supplied, it will automatically create one. In doing so, it will parse camelCase or PascalCase field names and intelligently capitalize and space accordingly to come up with a friendly title.
numberOfSkuscolumn is not supplied. In the new table, the title will automatically be
Number Of Skus.
pricecolumn to currency one decimal place using the
C1parameter in the
formatfunction. This value will be set into the
Formatproperty for the column in the resulting table.
quantitywill be aggregated using
sum. It will have the same name and be formatted to numeric one decimal place using
pricecolumn will be averaged using
avgand it's name changed to
avg_price. It will be formatted to currency one decimal place using
ordercolumn is included in the new data table, so the calculated column
quantityis broken out by
more_quantity, is calculated as the
10and returned in a new table. This is done using a custom function and a delegate
row. The function will also have the index position and all rows in the data table available as it is being evaluated.