DataPalooza 2021

DATA UPLOAD WORKSHOP

Figure 11 - Visualization

LINKING TO OTHER DATASETS Recall, when we were preparing our data, we changed FDIC Cert in our new dataset to an attribute. Now find that attribute, Right-click, and press “Link to Other Dataset…”. We will want to link it to Bank Cert from our existing dataset.

Figure 12 - Link to Other

When linked our grid will be updated to mostly blank cells. This is nothing to worry about. The datasets defaults to Outer Join which means that it combines all the rows from the two tables. The downside of this is some of the rows don’t match up and are returning blank cells.

9 | P a g e