Joins - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
How Do I
Reference
Overview
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552

Use the Joins builder to combine data from columns of two physical model tables before it is populated to the logical model columns.

Prerequisites of using joins is:
  • You have at least two physical model tables dragged to the canvas
  • You have defined one or more transformations on the logical table

Example: The Name column in the Product table of your logical model is linked to the Product Name column of Product_A physical table. However, you want to pull in data from another physical table Product_B.

In such a case, you can join the Product Name column of Product_A physical table with the Product Name column of Product_B physical table so that data populated in the logical model is a combination of data between the two physical tables (on the basis of the selected join type).