Data Validator supports the data import from two types of CSV file formats, which allows the same validation rules to be used regardless of the imported data file and the exported data to be in the same invariant format as the target system.
-
CSV file format.
-
CSV raw attribute file format (inverted file format).
For more information on using computed columns and functions, see Use the Computed column.
Each CSV file format is explained as follows:
CSV file format
The CSV file format is a standard delimited text file that uses a comma, or other separators, to separate values for columns in a spreadsheet. For example:
This information is shown in the staging area as shown in the following illustration:
CSV Raw Attribute file format (inverted file format)
CSV Raw Attribute file format is used to load design properties. This is when a single object has many properties that makes it impractical to represent each property in its own column. Each row in the CSV Raw Attribute file format refers to a different property definition, whereas the property definition is named in the column mapping for a standard CSV file. For example:
This information is shown in the staging area as shown in the following illustration:
