Follow-On Topics

Related Topics

# About the Format as Flat File Tool

The Format as Flat File tool takes a King Task Centre recordset and converts it into a flat file to be used by another task step or external program. The flat file output can be delimited or fixed width. You can also choose whether the flat file contains data for single or multiple record types.

At the time of writing, only King Task Centre recordsets can be formatted as flat files.

## What is a Flat File?

A flat file (also referred to as a "flat file database") stores unstructured data in plain text format. It does not contain:

|  | Any internal hierarchy

|  | Any links to other files

|  | Any word processing information or formatting

For King Task Centre, a flat file contains a single table of data, with one record per line. You specify the data type of each column and use delimiters to separate each column in a record.

## Features

The following features are available:

|  | Output a document used by other steps in the task

|  | Single or multiple document output

|  | New document created when data changes or for each new row

|  | Support for delimited and fixed width files

|  | Support for common and custom delimiters

|  | Support for common and custom end of row markers

Copyright © 2018 Quadrant Software B.V. All rights reserved.