AT.FIELDTYPE

This function returns the field type (text, numeric, date, etc.) of a field in an attribute table. String, Numerical, Logical and Date are the four types of attribute type.

Syntax

AT.FIELDTYPE(Database alias,Dimension,Attr_Tab_Id,Field)

Attr_Tab_Id is the number of the attribute table being examined (1, 2 or 3) and Field is the name of the field whose type is being requested.

The function returns:

C for String

N for Numerical

L for Logical

D for Date

The Products dimension on the Best Practices OLAP database alias has two attribute tables and the fields in the first attribute table are "ElemType", "Name", and "OrderPos". This formula returns "C":

AT.FIELDTYPE("Best Practices OLAP","Product",1,"Name")

The first two and last arguments for this function may be strings or references to cells containing strings.Strings must be enclosed in quotes. The Attr_Tab_Id argument must be a number between 1 and 3 or a reference to a cell containing a number between 1 and 3.