Script Range Dictionary Destination

Overview

Data flow destination, creating custom-crafted IDictionary object. The created dictionary object is a more memory-efficient representation of "many to one" relationships and can be used in the Lookup Plus component to perform lookups.

Setup

The script has the following parameters:

• StartColumn - select input column containing range start.
• EndColumn - select input column containing range end.
• ValueColumn - select input column containing range value.
• ResultVariable - select package variable to store custom range dictionary.