Joining Data

A screen shot of a window showing the settings for Microsoft Outlook and working with full outer joins.

Working with full outer joins

Working with full outer joins Often times we find as data workers we are trying...
A screen displaying the settings for a Microsoft Excel spreadsheet, utilizing anti joins to search for data.

Using anti joins to search for data

Using anti joins to search for data We know that data sets cannot be achieved...
The goal is to join data with common data between two unrelated data sets, ensuring one list has an established key and incorporating that key into the other lists.

Joining data with common data between two unrelated data sets

Joining data with common data between two unrelated data sets Joining data is part of...
When we are missing a key field, we have to determine how to join the data by creating unique identifiers between two data sets.

Creating unique identifiers between two data sets 

Creating unique identifiers between two data sets When a join is required, and the field...