Defining Table Properties in a Data Map to Normalize an Array

Back Next

GenVRowKey

Generates multiple table rows identified by unique row numbers from a row created from a source row that contains an array.

This function enables you to differentiate among multiple target rows created by a single source row. For example, if a source file contains an array and a child table is created from the array, use this function to populate a target field with unique multiple table rows for rows that would otherwise be identical.

For data rows with an OCCURS clause, a single row is returned for each instance of the OCCURS.

Syntax: