Join stage: Join keys category

Key

Choose the input column you want to join on. You are offered a choice of input columns common to all links. For a join to work you must join on a column that appears in all input data sets, that is, have the same name and compatible data types. If, for example, you select a column called "name" from the left link, the stage will expect there to be an equivalent column called "name" on the right link.

You can join on multiple key columns. To do so, repeat the Key property. You can use the Column Selection dialog box to select several key columns at once if required).

Key has a dependent property:

• Case Sensitive

  Use this to specify whether each group key is case sensitive or not, this is set to True by default, that is, the values "CASE" and "case" in would not be judged equivalent.