Converting flat data to a list - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155

Process List is a tool you can use within a service or subflow to turn flat data into a list.

This feature is useful if your dataflows include stages that require list input, such as those in Spectrum Spatial.
  1. With an existing flow in place, right-click the stage whose output you want to convert into a list. This could be any stage except Input or Output.
  2. Select Process List. You will see the stage within a blue square background.
  3. To move a stage into and out of the process list, press the Shift key while dragging the additional stage.
    Note: If you have several stages whose data you would like Process List to handle, consider creating a subflow, bringing it into your flow, and applying the Process List feature to the subflow as a whole.
  4. The input and output fields of a process list are called "ListField." Using the Rename Fields function, you must map your input stage field to "ListField" in the input channel, and map "ListField" to your output stage field. For more information, see Changing a field name.
  5. If you want the list to keep the data in original input order, right-click the Process List box and select Options.
  6. Check the Maintain sort order box.
  7. To confirm that the data input into the next stage will be formatted as a list, validate or inspect the flow. For more information about inspecting data, see Inspecting a flow.