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/Output

Number of Connections: Min: 1/Max:Unlimited

Input	Data Type	Description
InputN	String	The key.

Output	Data Type	Description
OutputN	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 InlineTable.
Type	choice	Specifies the table's format. CSV [CSV] - CSV format. Specifies the column for the key and the value in KeyColumn and ValueColumn. key=value [key=value] - Each record in the table will take the form of "key=value".
HomeDirectory	pathResolver	Specify the base folder of relative path of table file. Project folder [Relative] Start point is the same folder as the project file. Home folder [ProjectOwner] Start point is the projedct owner's home folder. Executing user home folder [ExecuteUser] Start point is the execute user's home folder.
FilePath	remoteFile	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	string	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	string	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 [Null] An empty String ("") is output. Key [Key] The input key is passed directly as output. DefaultValue [DefaultValue] The DefaultValue is output. If Type is "CSV" and the multiple value columns are defined, all value of columns are set to DefaultValue. Exception [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

Example2

		Property
Input1	D002	Mode	File	Output1	MN345
Input2	B	Type	CSV	Output2	JKL
		FilePath	../multitable.csv
		FileEncoding	(AutoDetect)
		KeyColumn	1,2
		ValueColumn	3,4
		IllegalKey	Key

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

D001,A,MN123,ABC

D001,B,MN123,DEF

D002,A,MN345,GHI

D002,B,MN345,JKL

D003,A,MN567,PQR

D003,B,MN567,STU