Configuring column content types for CSV files

Available column content types

When Textual processes a CSV file, it identifies the content of each column as one of the following:

• Sensitive - The column values are of a single type and format, and the values match an entity type.

• Not sensitive - The column values are of a single type and format, but the values do not match an entity type.

• Unstructured - Each column value might contain multiple entities of different types. For example, a column that contains notes or a longer description.

Selecting the column content type

From the file preview, you can review and change the content type assignments for each column.

To change the assigned CSV column content type:

1. In the output table heading, click the dropdown icon.

Column configuration panel for a CSV column

1. On the configuration panel, click the column content type.

2. If you clicked Sensitive, then from the Column entity type dropdown list, select the entity type for the column values. Textual displays the current configured handling type for the selected entity type.

3. If you clicked Sensitive or Not Sensitive, then to save the changes, click Save. Changing the content type to Unstructured requires a rescan of the file. If you clicked Unstructured, then:

   1. To save the changes and rescan the file, click Save & Scan.

   2. To save the changes, but not rescan the file, click Save. If you save without rescanning the file, then Textual marks the file as requiring a rescan.