function

maniram23 — Sun, 28 Jun 2015 07:09:18 GMT

Hi experts,

what are the table functions? give me an example of each and every one.

Re: function

jagan — Sun, 28 Jun 2015 07:12:29 GMT

Hi Mani,

Check this functions

The table functions return information about previously loaded data tables.

FieldName(nr ,'TableName')

Returns the name of the field with the specified number within a previously loaded table.

If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET a = FieldName(4,'tab1');

T1:
Load a, b, c, d from abc.csv
T2:
Load FieldName (2, 'T1') Autogenerate 1;

FieldNumber('field ' ,'TableName')

Returns the number of a specified field within a previously loaded table.

If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET a = FieldNumber('Customer','tab1');

T1:
Load a, b, c, d from abc.csv
T2:
Load FieldNumber ('b', 'T1') Autogenerate 1;

NoOfFields([ 'TableName ' ])

Returns the number of fields in a previously loaded table.

Examples:

LET a = NoOfFields('tab1');

Load *, NoOfFields( ) from abc.csv;

NoOfRows('TableName ' )

Returns the number of rows (records) in a previously loaded table.

If the function is used within a load statement, it must not reference the table currently being loaded.

Examples:

LET a = NoOfRows('tab1');

Load * from abc.csv where NoOfRows( )<30;

NoOfTables()

Returns the number of tables previously loaded.

TableName( 'TableNumber' )

Returns the name of the table with the specified number.

If the function is used within a load statement, it must not reference the table currently being loaded.

TableNumber( 'TableName' )

Returns the number of the specified table.

If the function is used within a load statement, it must not reference the table currently being loaded.

robert_mika — Sun, 28 Jun 2015 16:05:14 GMT

Just to add:

Function	Syntax	Front End	Back End
FieldName	str FieldName (field_number, table_name)	No	Yes
FieldNumber	int FieldNumber (field_name, table_name)	No	Yes
NoOfFields	int NoOfFields (table_name)	No	Yes
NoOfRows	int NoOfRows (table_name)	Yes	Yes