Using the Spotfire® Streaming Gather operator with a multi-field key

Issue

How do I use the Gather operator to gather on a more than one field? My unique key values are spread across more than one field in the input schemas.

Solution

Gather does not directly support multi-field keys.

One way to work around this limitation is to create a key field in each input port's schema that is a tuple whose fields are all the fields that make up your multi-field key and then have that field be the Key field by which to gather tuples.

And the ABGather Gather Settings:

Attached as gatherbymultikeyfield.zip is a Spotfire® Streaming 7.5.1 Studio project that illustrates this idea.

Attachments

You can download attachments from resources.

gatherbymultifieldkey.zip