LookupTableReaderWriter
We assume that you have already learned what is described in:
If you want to find the right Other component for your purposes, see Others Comparison.
Short Summary
LookupTableReaderWriter reads data from lookup table and/or writes it to lookup table.
| Component | Same input metadata | Sorted inputs | Inputs | Outputs | Each to all outputs1) | Java | CTL |
|---|---|---|---|---|---|---|---|
| LookupTableReaderWriter | - | no | 0-1 | 0-n | yes | no | no |
1) Component sends each data record to all connected output ports.
Abstract
LookupTableReaderWriter works in one of the three following ways:
Receives data through connected single input port and writes it to the specified lookup table.
Reads data from the specified lookup table and sends it out through all connected output ports.
Receives data through connected single input port, updates the specified lookup table, reads updated lookup table and sends data out through all connected output ports.
Icon
Ports
| Port type | Number | Required | Description | Metadata |
|---|---|---|---|---|
| Input | 0 | 1) | For data records to be written to lookup table | Any |
| Output | 0-n | 1) | For data records to be read from lookup table | Input 01) |
Legend:
1): At least one of them has to be connected. If the input port is connected, the component receives data through it and writes it to the lookup table. If an output port is connected, the component reads data from the lookup table and sends it out through this port.
If the input port is connected and the component cannot write into the Lookup table (see LookupTableReaderWriter Attributes) you have specified, an error will be shown.
![[Important]](figures/important.png) | Important |
|---|---|
Please note writing into Database lookup table is not supported. You should use DBOutputTable instead. |
LookupTableReaderWriter Attributes
| Attribute | Req | Description | Possible values |
|---|---|---|---|
| Basic | |||
| Lookup table | yes | ID of the lookup table to be used as
| |
| Advanced | |||
| Free lookup table after finishing | By default, contents of the lookup table are not deleted
after the graph finishes. If set to true,
the lookup table is emptied after the processing ends. | false (default) | true | |