TABLE

The TABLE function returns the data from a CSV or Properties file associated with the specified key.

The input is the key to search for in the specified file.

Each record in a CSV file takes the form of "key,value". Each record in a Properties file takes the form of "key=value".

Input

Number of Connections: 1

Input	Data Type	Description
Input1	String	The key.

Output

Output	Data Type	Description
Output1	String	The data associated with the specified key.

Property

Name Property Type Description

Mode

choice

Specifies whether the input table is to the read from a file or to be defined by the InlineTable property.

File	-	Read the table data from a file.
Inline	-	Receive the table data from the input stream.

Type

choice

Specifies the table's format.

CSV	-	CSV format
key=value	-	Each record in the table will take the form of "key=value".

FilePath

String

If Mode=File, this property specifies the file to read the table data from.

If the file is specified using a relative path, then the base directory is the project owner's home directory.

FileEncoding

choice

If Mode=File, this property specifies the table file's character encoding.

(AutoDetect)	-	Attempts to automatically detect and select the character code.
utf-8	-	Unicode utf-8
shift_jis	-	Shift JIS
euc-jp	-	EUC-JP
iso-2022-jp	-	ISO-2022-JP
Windows-31J	-	Windows Japanese
utf-16	-	Unicode utf-16

InlineTable

String

If Mode=Inline, this property specifies the table's data.

KeyColumn

int

If Type=CSV, this property specifies which field in the table's records are to be used as the key field.

A record's first field is indexed as 1.

ValueColumn

int

If Type=CSV, this property specifies which field in the table's records are to be used as the value field.

A record's first field is indexed as 1.

IllegalKey

choice

Defines what is to be output if no data exists for the specified key.

Null	-	An empty String ("") is output.
Key	-	The input key is passed directly as output.
DefaultValue	-	The `DefaultValue` is output.
Exception	-	An Exception is thrown.

DefaultValue

String

The default value to be output when IllegalKey is set to DefaultValue and no matching key field is found.

Topic

If multiple matches are found in the table file, the final matching data is returned.
The specified table file is only read the first time the function is called. As a result, what is read the first time the function is called is used until the end of flow processing. For example, if a function is called two or more times in the same flow as a result of looping, or calls to a sub-flow, only the table file contents read by the first function call are used until the end of flow processing. Furthermore, when a file is read, it is checked to see if it has been updated since the last time it was read by the function. So, if a table file has not been updated, a table file will not be read again the next time the function is called as a result of new flow processing initiated by a new processing request.

Example

		Property		Output
Input 1	D002	Mode	File	MN345
		Type	CSV
		FilePath	../table.csv
		FileEncoding	(AutoDetect)
		KeyColumn	1
		ValueColumn	2
		IllegalKey	Key

The ../table.csv file's content used in the example above is listed below:

D001,MN123

D002,MN345

D003,MN567

D004,MN789