40.23 Lookup Tables
40.23.1 Overview ¶
In the Lookup tables area you manage tabular mappings that map email properties (e.g. sender domain) to result values. These values can then be used as placeholders in tasks - e.g. “Save the attachments under the client name that belongs to the sender domain”.
The typical use case: A sender domain like mueller-gmbh.de should be assigned to the client name “Mueller GmbH”. Instead of building this logic anew in every profile via a filter, the table is maintained centrally once and referenced in the task via the placeholder <CSVMapping{Clients}>.
40.23.2 Toolbar ¶
| Button |
Effect |
| Add… |
Opens the editor to create a new lookup table |
| Edit |
Opens the selected table for editing |
| Remove |
Removes the selected table after a confirmation prompt |
A double-click on an entry opens the editor.
40.23.3 List Columns ¶
| Column |
Description |
| Name |
User-assigned name (e.g. “Clients”, “Cost centers”) |
| Match by |
Which email property serves as the key (e.g. sender address, domain, subject) |
| Entries |
Number of rows in the table |
40.23.4 Create or Edit a Table ¶
Several areas are available in the editor:
General
| Field |
Description |
| Name |
Unique name of the table, later used for the placeholder |
Match columns
Defines which email properties form the key for the table. Multiple columns are allowed - the match is then against the combination of values. Typical columns: sender address, sender domain, recipient, subject fragments.
Result column
Defines the data source for the result value - usually an additional column in the table whose value is returned on a match.
Data
Tabular entry of the mapping rows with the following operation buttons:
| Button |
Effect |
| Row above |
Inserts an empty row above the current one |
| Row below |
Inserts an empty row below the current one |
| Rows from clipboard |
Imports multiple rows from the clipboard (e.g. copied from Excel) |
| Duplicate row |
Creates a copy of the current row |
| Delete rows |
Removes the marked rows |
40.23.5 Use in Tasks ¶
In a task (e.g. Save attachments, Forward email) the table is referenced via the placeholder. When processing an email:
- The program reads the email properties defined in the match columns
- Searches the table for a row whose values match exactly
- Returns the value of the result column
- Inserts this value in place of the placeholder
If the match finds no hit, the placeholder remains empty (or receives a default value, depending on the table configuration).
40.23.6 Use Case ¶
Client mapping
Table: “Clients”. Match column: sender domain. Result column: client name. Rows: mueller-gmbh.de -> Mueller GmbH, schulze-kg.de -> Schulze KG. In the Save attachments task the path is configured as D:\IncomingInvoices\<CSVMapping{Clients}>\<Date> - emails land automatically in the correct client folder.
40.23.7 Tip ¶
- For large tables (>500 entries), the Rows from clipboard function is fastest - copy the data from Excel and paste it in one go