Relationships tab

Application database > Analytical Workspaces tile > workspace tile > Virtual Datasets and Datasources tab > virtual dataset tile > tab

Application database > Navbar > Analytic Information hub > workspace tile > Virtual Datasets and Datasources tab > virtual dataset tile > tab

Purpose of the tab

This tab allows you to create relationships between physical dataset fields or between physical dataset fields and workspace dictionaries. These relationships determine the list and values of the fields available for the virtual dataset.

Fields in the tab

Element	Description
Dataset 1, Dataset 2	Selects the fields of the workspace's physical datasets to be related.
Include all records	Allows you to include physical dataset records in the set of records returned by the virtual dataset, even if one of the fields related is empty (Left outer join, Right outer join, Full outer join).
Add the field relationships between the two datasets	Allows you to associate the individual fields of physical datasets with each other.