Rebuild Headers / Define Headers and Transform Data

This block enables you to map and manipulate the data in the input file during file transfer. Below is the screenshot of the block.

The table contains the fields and their descriptions.

Field	Description
Headers Mapping	Map the column headers or headings according to the input file. Syntax: `{"heading1 of output file":"heading1 of input file", "heading2 of output file":"heading2 of input file"}` Example: `{"TAmount":"t_amount", "BillID":"Bill_Number"}` Here, `t_amount` and `Bill_Number` in the input file are stored as `TAmount` and `BillID` respectively in the output file. The information in the input and output files is identical. You can manipulate or change the information in the output during file transfer. This is done by using expressions. Example: `{"TAmount":exp{hdr"t_amount"+1}}` Here, `t_amount` in the input file is stored as `TAmount` in the output file. Each value under `TAmount` in the output file is the value from `t_amount` in the input file increased by 1. See Example use case for details.
Output Headers Order	Specify the order of column headers in the output file or skip columns during the transfer. The headings should be comma-separated without spaces between them. Syntax: `heading1,heading2` Example: `TAmount,bill_name,BillID` See Example use case for details.
Input File Delimiter	File delimiter separates fields in the input file.
Output File Delimiter	File delimiter separates fields in the output file. Delimiter allowed: pipe (\|), comma (,) ampersand (&), per cent (%). Alphabets and numbers cannot be delimiters.
Output Filename	Name of the output filename with extension. Extensions allowed: .txt or .csv. The output filename cannot be null. Ensure that the output filename matches the one specified in the Connect to destination block.
Is the file headerless?	Select the check box if the columns in the input file do not have a header.
Mention header names (for use in mapping and expressions)	Define the column header or heading in the output file if the input file does not have a heading or column header. There cannot be spaces between two heading names and do not use double quotes. Syntax: `heading1,heading2` Example: `TAmount,BillID` See Example use case for details.