Illustrated in the below image is a flow where the Header Picker reader step is used to read headers from a file. The filter step is used to filter for specific data requirements and a Buffer destination step to store the data in.
Adding a Header Picker Reader Step
To add a Header Picker Reader step in a flow, follow the instructions below:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for a Reader step to pull out the source data. Click on the Reader tab and select Header Picker as shown in the image below.
Configuring a Header Picker Reader Reader step
Illustrated below is the configuration that is available in the Header Picker Reader step.
String Encoding – Synatic currently only applies the UTF8 encoding. This cannot be changed.
For more information on UTF8, click on the link below.
Row Delimiter field – The characters indicating the end of a row. CR LF is selected by default when the step is added.
The Headers section – Where the Header configuration is set. There can be multiple headers that are defined. To add more headers, click on the plus button as highlighted in yellow in the image above.
Name section – The name to be used for the header.
Fields section – Used to map fields from the file. To add a field, click on the plus icon highlighted in green, fill in the details and click on the tick on the far right of the field.
The Fields configuration table contains the following columns that must be set.
Name column – The name of the field.
Row number – The row to pick the field from.
Start Position – The start character within the row.
Length column – The number of characters that are extracted from the row.
Type column – The data type. This could be a String, Number, Boolean or any other data type required. Select the required from the dropdown list.
Decimal column – The number of decimals to round the field to.
Trim column – Remove any specified characters from the field.
Left Trim column – Remove any specified characters from the left of the field.
Right Trim column – Remove any specified characters from the right of the field.
Using a Header Picker Reader step
To use a Header Picker Reader step, follow the below instructions:
Click on the play button on the Header Picker Reader step as highlighted in the image below:
2. Click the highlighted are in the image below to upload a file.
3. Click the Test button as shown in the image below.
