Follow-On Topics

Related Topics

# Technical Summary

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.

## Working with Other Tools

The other tools that a Format as Flat File step can interact directly with, either by exposing information to it or consuming information from it, are listed below:

### Consuming from Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Database Query (ODBC) | Input and Data Connectors
| Database Query (OLEDB) | Input and Data Connectors
| Import Flat File | Input
| Import XML Document | Input
| Convert Recordset to XML | Format
| Convert XML to Recordset | Format
| Transform Data | Format
| Call Task | Execute
| Filter Data | General

### Objects Consumed

Objects exposed by other steps that the Format as Flat File tool consumes are listed below:

|  | Recordset — Information structured into columns and rows

|  | Variables (Text) — Textual data is extracted from selected variables

### Exposing to Other Tools

Icon | Tool Name | Tool Category
--- | --- | ---
| Print Document | Output
| Save File | Output
| Send Email (SMTP) | Output
| Send Fax (Tobit) | Output
| Send Text Message | Output
| Transfer File (FTP) | Output
| Call COM Object | Execute
| Run External Program | Execute
| Web Service Connector | Data Connectors

### Objects Exposed

Objects exposed by the Format as Text step that can be consumed by other steps are listed below:

|  | Documents (Text) — One or multiple plain text documents

|  | RecordSource — Displays the data provided by the previous Step in the Task

|  | Step Properties — A number of properties for the Step are exposed in the Environment tab of the Task Browser dialog box

## Global Configuration

Global configuration is not required for the Format as Flat File tool.

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