×
Menu
Index

Tables

 

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.