Add, view, edit, and delete fields for file formats

Add file fields

New file fields can only be defined in delimited, fixed-width, and JSON file formats. Use the following steps to create a new fields.

1. Navigate to Settings → Data Format, click the hyperlink of a format Name from the corresponding column. From there, an inventory-like screen will be available with several listed fields.

You can also navigate to the Data Format page from any Environments Inventory tab by clicking on the Edit File Format button. An information banner is added on the Environments Inventory page to help user with navigation.

2. Click on + Field button appearing on the left corner just above the grid, to open an Add Field dialogue.

   

If you select a DATESHIFT algorithm or multi-column algorithms, more fields will appear in the dialogue. A DATESHIFT algorithm allows you to pick a date format from the dropdown list or specify your own date format.

3. Fill out the form and click Save.

4. The Field Name or JSON Path and all inputs in the Formatting section are mandatory.

5. The Masking section is optional and can be edited later as well.

6. Newly added fields will be reflected under the selected record type group on the page.

Constructing a JSON path

A JsonPath expression begins with the dollar sign ($) character, which refers to the root element. The dollar sign is followed by a sequence of child elements, which are separated by the square brackets ([‘’]) containing the name of each JSON field. If the field is inside an array, a star character is used to represent all elements of the array ([*]).

View, edit, or delete a file field

1. The fields can be viewed, edited, or deleted using the Action menu (…) to the right of the corresponding field.

   

2. The View is a read-only pre-filled dialogue (similar to Add Fields) and the user can not make edits.

3. Edit prompts a pre-filled dialogue (similar to Add Fields) and the user can make edits as needed.

4. Delete action, the user will be prompted for confirmation to Delete a field. Fields from XML and Mainframe formats cannot be deleted.

Edit action for a field can be used from the Inventory screen as well for algorithm assignment and setting up automatic updates only (Masking section only).