Flat Files

The flat file type (.flat) is used with ASCII files (.asc), which contain fixed-length fields and optional line ends to mark the end of records. The actual ASCII data does not contain any information about the structure of fields nor the data types of those fields. For information on data types, see Data Types.

Reading and writing flat files

Use an Input Data Tool and Output Data Tool to read and write .flat files. If you are reading an unknown file type into Alteryx and have selected the Read it as a fixed width text file option, see Flat File Layout.

Flat file structure

The .flat file is written in XML and can be modified to describe information about the structure and data types of fields. The root element is flatfile with a version attribute, which has to be "1". The flatfile element contains the following child elements: