This steps provides a set of attribute fields that can be used to both map the output schema from the file columns and also for the columns that will be included in the output.
These may not necessarily be the same fields. For instance you may want to output the delivery address 1 line field, "address_01", that is the first line of an address. However, the input columns contain multiple components to the first line that will need to be put together for the address. In this case, you need to create the fields for both sides. Additionally plan to use field names that can be used in multiple output schemas to minimize redundant fields.
To create the fields, do these steps:
- Click on "Data Mapping" in the left navigation bar.
- Click on the "Available Fields" tab on the top menu
- To create a field do these steps
- Click on the Add button. A dialog box appears
- Enter one (or more if "Add Multiple" is checked) field names
- Choose the datatype
- You can select existing output schemas if you want to, but is not needed
- Click add to close the dialog
- Important: Click on the Save button on the bottom right of the main page to really save
Once you have created the fields, you can also add some attributes to the field as needed by checking the relevant checkbox next to it, such as setting the output value to upper case, profiling the column, adding a minimum and maximum value for the field. Remember to again click the Save button to commit the changed. Many of these attributes are also in the output schema configuration.