DSXchange

In DS 7.1 server edition I am trying to split an input row into multyple rows. The data in the row tha needs to be split is delimited by ;

To do this i use Convert(";", @VM, FIELD2) In a transformer and load it into a hash file as a non key column.

When i read the same hash file on the output link i am not able to slect "Normalize on" field. It is grayed out. How do i enable this feature.

Thanks.

You need a VOC record for that, so the hashed file has to be created in an 'account' rather than pathed or you need to create the VOC record manually.

For "normalize on" to be enabled you need one or more fields defined as being able to handle multi-valued data.

There is a check box in the table definition in the Repository that allows you to indicate support for multi-valued fields. When this is selected the Columns grid includes three new columns; type, position and assoc. It is here that you can specify multi-value handling, and thus "enable the feature".

This is available for UniVerse, UniData and Hashed File stages.

Importing table definitions for these where the database object supports multi-valued data automatically records that fact in the table definition.