Yes. You can read or write an Amazon S3 file that does not contain a header.

Set the following properties in the

Formatting Options

tab when you configure the Amazon S3 V2 source and target properties in a mapping:

In the
Header Line Number
source property, enter
0
as the line number.
In the
First Data Row
source property, enter
1
as the line number.
In the
Target Header
target property, select the
With Header
option.

When you run the mapping task, the Secure Agent reads data from the file that does not contain a header and writes the data to the file adding a header.

For example, you want to read data from the following Amazon S3 file that does not contain a header:

After you set the required properties in the

Formatting Options

tab, the Secure Agent displays the data in the

Data Preview

tab in the following format:

When you run the mapping task, the Secure Agent reads data from the file that does not contain a header and writes the data to the file adding a header in the following format:

Set the following properties in the

Formatting Options

tab when you configure the Amazon S3 V2 source and target properties in a mapping:

In the
Header Line Number
source property, enter
0
as the line number.
In the
First Data Row
source property, enter
1
as the line number.
In the
Target Header
target property, select the
Without Header
option.

When you run the mapping task, the Secure Agent reads data from the file that does not contain a header and writes data to the file without a header.

For example, the Secure Agent reads data from the file that does not contain a header and writes the data to the file without a header the following format when you run the mapping task:

Set the following properties in the

Formatting Options

tab when you configure the Amazon S3 V2 source properties in a mapping:

In the
Header Line Number
property, enter the line number that you want to use as the header when you read data from Amazon S3.
In the
First Data Row
property, enter the line number of the Amazon S3 file from where you want the Secure Agent to read data.
If you want to read data from the header, the value of the
Header Line Number
and the
First Data Row
properties should be the same.
In the
Target Header
target property, select the
Without Header
option.

When you run the mapping task, the Secure Agent reads data from the file that contains a header and writes data to the file without a header.

For example, you want to read data from the following Amazon S3 file that have a header:

Set the

Header Line Number

property to

3

and

First Data Row

property to

4

in the

Formatting Options

tab. The Secure Agent displays the data of an Amazon S3 file that have a header in the

Data Preview

tab in the following format:

The Secure Agent reads data from the file that contains a header and writes the data to the file without a header in the following format when you run the mapping task:

Set the following properties in the

Formatting Options

tab when you configure the Amazon S3 V2 source properties in a mapping:

In the
Header Line Number
property, enter the line number that you want to use as the header when you read data from Amazon S3.
In the
First Data Row
property, enter the line number of the Amazon S3 file from where you want the Secure Agent to read data.
In the
Target Header
target property, select the
With Header
option.

When you run the mapping task, the Secure Agent reads data from the file that contains a header and writes data to the file with a header.

For example, you want to read data from the following Amazon S3 file that have a header:

Set the

Header Line Number

property to

3

and

First Data Row

property to

4

in the

Formatting Options

tab.

The Secure Agent reads data from the file that contains a header and writes the data to the file with a header in the following format when you run the mapping task: