LookupTableReaderWriter

CloverDX Designer > Component Reference > Others > LookupTableReaderWriter

Short Description

Ports

LookupTableReaderWriter Attributes

Details

Short Description

LookupTableReaderWriter reads data from a lookup table and/or writes it to a lookup table.

Component	Same input metadata	Sorted inputs	Inputs	Outputs	Each to all outputs^[1]	Java	CTL	Auto-propagated metadata
LookupTableReaderWriter	-	⨯	0-1	0-n	✓	⨯	⨯	⨯

Component

Same input metadata

Sorted inputs

Inputs

Outputs

Each to all outputs^[1]

Java

CTL

Auto-propagated metadata

LookupTableReaderWriter

⨯

0-1

0-n

✓

⨯

¹	Component sends each data record to all connected output ports.

Ports

Port type	Number	Required	Description	Metadata
Input	0	^[1]	For data records to be written to a lookup table	Any
Output	0-n	^[1]	For data records to be read from a lookup table	Input 0^[1]

Port type

Number

Required

Description

Metadata

Input

^[1]

For data records to be written to a lookup table

Any

Output

0-n

^[1]

For data records to be read from a lookup table

Input 0^[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.

Please note writing into Database lookup table is not supported. You should use DatabaseWriter instead.

LookupTableReaderWriter Attributes

Attribute Req Description Possible values

Attribute	Req	Description	Possible values
Basic
Lookup table	yes	ID of the lookup table to be used as a source of records when the component is used as a reader, or a deposit when the component is used as a writer, or both when it is used for both reading and writing.
Advanced
Clear lookup table after finishing		When set to `true`, memory caches of the lookup table will be emptied at the end of the execution of this component. This has different effects on different lookup table types. Simple lookup table and Range lookup table will contain 0 entries after this operation. For the other lookup table types this will only erase cached data and therefore make more memory available, but the lookup table will still contain the same entries.	false (default) \| true

Basic

Lookup table

yes

ID of the lookup table to be used as

a source of records when the component is used as a reader, or
a deposit when the component is used as a writer, or
both when it is used for both reading and writing.

Advanced

Clear lookup table after finishing

When set to true, memory caches of the lookup table will be emptied at the end of the execution of this component. This has different effects on different lookup table types. Simple lookup table and Range lookup table will contain 0 entries after this operation. For the other lookup table types this will only erase cached data and therefore make more memory available, but the lookup table will still contain the same entries.

false (default) | true

Details

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.