Entering the 'Get Table Data' Formula Directly

The inserted Excel formula for the 'Get Table Data' command is shown below.

=AFGetTableData (System, Database, Query Value, Result Column Name, Query Column Name, Table Name, Outcode)

The following table lists the formula arguments.

Get Table Data Formula Arguments

Argument	Description
System (string)	Sigmafine Server name.
Database (string)	Database name.
Query Value (string)	Query comparison value used to select the row from the Query Column Name.
Result Column Name (string)	Column of the selected row(s) from which results are returned.
Query Column Name (string)	Column name used to match an entry or entries with the query value.
Table Name (string)	Table name for the query and results.
Outcode (number)	For Outcode values, see the "Output Code (Outcode) Table".