Introductie
One of the most powerful items in SoftRules® is the Table. Using these decision tables information can be fetched from a list based on an indexfield and decision criteria. Calling a Table is done from an Assignment. You can find all calls to a specific Table by using Find references in the Context menu.
Versions
When multiple Versions of this Table are available, another Version can be selected. Which Table will be used at runtime depends on the Conditions at Configuration level.
New version
After clicking New version the above dialogue appears. You can select one of the Version declared at Configuration level. With the Edit button you can view or eventually modify this Version. Using Copy previous version the Table
from the previous version will be copied to the new Version. This way you want have to begin from scratch.
Delete version
Using the Delete version button you can remove an instance of a Version. You can't remove the Base Version.
Description
The description of the Table. This will also be visible in the tree structure together with the Tools that use the Table. Make sure to chose a clear and logical description to make your Products more easy to read.
Index element
The content of the index element is used to search the Table.
Alt. path (L)
The path to the index element.
Match found element
When used this element will contain a 1 if the value is found and a 0 of not (or the Default row is returned).
Alt. path (R)
Path to the Match found element.
Default row
When checked, a Default row will appear at the bottom of the Table and if no match is found this value will be returned.
Round to nearest
When checked and the index element contains a value that is somewhere in the middle of two values in the Table, the result will be round to the nearest value.
Round to highest
When checked and the index element contains a value that is somewhere in the middle of two values in the Table, the result will be round to the highest value.
Round to lowest
When checked and the index element contains a value that is somewhere in the middle of two values in the Table, the result will be round to the lowest value.
Interpolate
When checked and the index element contains a value that is somewhere in the middle of two values in the Table, the result will be a calculated interpolation from the 2 values found in the Table, using the index value.
Extrapolate
When checked and the index value is larger than the last item in the Table, the result will be a calculated extrapolation, using the last and the previous value in the Table (and the indexvalue).
Insert Row
Inserts a row at the cursor position.
Delete Row
Deletes the row at the cursor position.
Append Row
Appends a row at the end of the Table.
Insert Column
Inserts a new column at the cursor position.
Delete Column
Deletes the column at the cursor position.
Append Column
Appends a new column to the right of the last column.
Sort
Sorts the rows, using the index column.
Import
Using this function you can import rows from a CSV file. First column will be the Index column. No header information is expected. You will have a choice to keep column headers.
Copy column
Copies a column to the clipboard.
Paste Column
Pastes a copied column at the cursor location.
Paste column as row
Pastes a column as a new row. Row Values will become column values.
Repeat on
When the Index element is empty, all (selected) column values will be returned. Select Simple Types or Complex Types. If you chose Complex Types the Elements will repeat using the Path entered in Alt. Path.
Columns
Each Column contains a header with Decisions that makes the Column valid. See here.