Converting Flat Data to a List

Process List is a tool you can use within a service or subflow to turn flat data into a list. This is useful if your dataflows include stages that require list input, such as those in the Location Intelligence Module.

  1. With an existing dataflow 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 dataflow, 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's Name.
  5. If you want the list to keep the data in the same order in which it was input, right-click the Process List box and select Options. Then check the Maintain sort order box.
  6. To confirm that the data input into the next stage will be formatted as a list, validate or inspect the dataflow. For more information on inspecting data, see Inspecting a Dataflow.