Clicking Design, opens the File Definition designer canvas.

The first time this is opened for your File Definition, this canvas will be blank.

This area creates, maintains, and displays dataviews belonging to your File Definition - regardless of whether they apply to Source or Destination files.

These dataviews tell Statelake what files and records are to be used, and how they are to be used.

image-20240317-004226.png

There is a different dataview for each file type as selected - a Flat File generates a File Dataview.

Existing File Definition Dataview

If a Dataview already exists, it will display here on the designer canvas, as illustrated below.

image-20240408-015402.png

Where a dataview exists and displays on the design canvas, the various tabs are accessible via the buttons on the dataview.

Dataview Tabs

Tab Name

Description

Preview

Click to see a preview of the data extracted by the query.

image-20240417-022209.png

Records

Click to open the Records tab.

image-20240415-235307.png

Fields

Click to open the Fields tab.

image-20240416-225026.png

Calcs

Click to open the Calcs tab.

image-20240416-225233.png

Link

Click to open the Link settings window. This will only be available to select where the dataview has a link to another dataview.

image-20240416-230143.png

New File Definition Dataview

To create the initial dataview for a new File Definition, or to add another dataview, select File and New (or Ctrl-N) to create a new dataview to configure.

While the following examples illustrate a File Dataview, all dataviews are created in the same manner.

image-20240408-015929.png

Make sure to select the appropriate dataview - in this case it is File Dataview. Click on OK to continue.

image-20240408-020026.png

Buttons

Button Name

Description

OK

Click to save any changes you have made. All changes will be lost if you do not click the OK button.

Cancel

Click to Cancel any changes you have made.