Load SystemField Content of $Field into Table

hugmarcel — Wed, 25 Sep 2013 10:34:44 GMT

is it possible to load the content of $Field into a Table, e.g.

load $FIELD autogenerate 1;

or similar?

thx - Marcel

Re: Load SystemField Content of $Field into Table

swuehl — Wed, 25 Sep 2013 11:33:00 GMT

Not 100% sure, but I believe the system fields like $Field will not be accessible prior script finished execution.

But you can access all field names loaded using the table functions in your script:

Table 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.

There are some examples here in the forum how to iterate over all tables, all field names, something like

FOR t = 0 TO NoOfTables() -1

LET vTableName = TableName(t);

// Loop through all fields/columns within the table

FOR vColumnCounter = 1 TO NoOfFields(vTableName)

LET vFieldName = FieldName(vColumnCounter, vTableName);

// DO SOMETHING

topic Load SystemField Content of $Field into Table in QlikView

Load SystemField Content of $Field into Table

Re: Load SystemField Content of $Field into Table

Table Functions