# File Wizard: Options

## File Parameters

File parameter settings

| Setting | Description |
| --- | --- |
| Labels | If the field names (column headers) are stored in the first line of<br>the table, this control should be set to Embedded.<br>The DIF format also allows field names to be explicitly specified, and<br>if that is the case, this control should be set to Explicit. If the table<br>contains no field names, the None alternative<br>should be used. |

## Clauses

Clauses settings

| Setting | Description |
| --- | --- |
| Where... | Opens the Where Clause dialog, with which is possible to create a where<br>clause for the load statement. |
| Clear | Revokes the transformation and/or the where<br>clause of a cross table. |

## Prefixes

Prefix settings

| Setting | Description |
| --- | --- |
| Crosstable | Opens the Crosstable dialog where it is<br>possible to set the parameters for a transformation of a cross table into<br>a three- (or more) column table. |
| Hierarchy... | Opens the Hierarchy Parameters<br>dialog, where it is possible to set the parameters for a hierarchy table<br>(parameters as they appear in the script in parentheses). |
| Clear | Revokes the transformation of a cross table or a hierarchy table. |

Note that if both a cross table transformation and a where clause are used, the where clause is evaluated first. It is thus not possible to first transform from a cross table and then apply a where clause. However, if there is a need to apply a where clause on an already transformed table, a construction with a temporary table will solve the problem:

`TempTable: Crosstable (…) Load … from …;` `RealTable: Load … resident TempTable where …;` `Drop Table TempTable;`