RangeTable

The RangeTable function returns the data from a CSV formatted range table associated with the specified key.

Multiple value can be output.

Range table's format is "Minumum value, Maximum value, value1, value2, ...".

Input/Output

Number of Connections: Min: 1/Max:Unlimited

Input	Data Type	Description
InputN	Integer,Double,Decimal,String	A key. If String value is passed, the value is converted to a numeric value. If conversion is failed, it is handled as a invalid key. The Boolean or DateTime value, and null is handled as a invalid 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.
RangeType	choice	Specifies a format to define the range min <== X < max [GELT] - Minimum <= key < Maximum min <== X <== max [GELE] - Minimum <= key <= Maximum
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.
MinColumn	int	Specifies the columns used as a minumum value of the range. The first column is indexed as 1.
MaxColumn	int	Specifies the columns used as a maximum value of the range. The first column is indexed as 1.
ValueColumn	string	Specifies the columns used as a value. If you specifies multiple columns as values, specify the concatenated string with comma. The first column is indexed as 1.
IllegalKey	choice	Defines what is to be output if no data exists for the specified key. Null [Null] A null is output. Multiple columns are selected as vakye columns, all columns are set to null. Key [Key] The input key is passed directly as output. Multiple keys or columns are selected, a value correspond order is set. DefaultValue [DefaultValue] The DefaultValue is output. The multiple value columns are defined, all value of columns are set to DefaultValue. Exception [Exception] An Exception is thrown.
DefaultValue	string	When the IllegalKey is "DefaultValue", specify the output value.

Loading table

When Mode is set to "File", contents of table is loaded at first execution in each request. This loaded contents is used in the same function in the same request until this request ends. In another words, the same loaded table is used even if the function is in the loop or it is used in subflow. When loading a table, it is checked whether the file is updated or not. If the file is not updated, it is not loaded in next request.

Topic

• Contents of the table
  If there is a duplicated range in the table, error is occurred. When "Mode" is set to "Inline", it become compole error. When "File" is set, runtime error is occurred.