Configuring KVP metadata

The Edge component must be configured with a Metadata definition for loading the key-value pair data.

1. In the Palette pane, click Edge and use it to connect the reader and the Add KVPs connector.
2. Right-click on the Edge and select New metadata > Extract from flat file. The Flat File dialog is displayed.
3. In the Flat File dialog, click the Browse button, which brings up the URL Dialog.
4. For the File URL property:
   1. Click inside its Value field, which displays a ... browse button.
   2. Click the browse button.
   3. Click the Workspace view tab and then double-click the data-in folder.
   4. Select the key-value pair source file and click OK.
5. In the Flat File dialog, make sure that the Record type field is set to Delimited and then click Next.
6. In the middle pane of the Metadata editor:
   1. Check the Extract names box.
   2. Click Reparse.
   3. Click Yes in the Warning message.
7. In the Record pane of the Metadata editor, make these changes:
   1. Click the Record Name field and change the default value to a name such as KVPs.
   2. Make sure that the Type field of all properties is set to type string. For example if the specKey property is set to integer, change it to string.
   3. Verify that all properties have the correct delimiter character set (which is the comma character in our example). At this point, the pane should look like this example:

      

   4. When you have input all your changes, click Finish.
8. Save the graph.