DataPalooza 2021

DATA UPLOAD WORKSHOP

To fix this we will want to scroll up to our existing dataset. There should be the three dots by the name, see figure 13. We’ll want to click the dots and select the Inner Join option.

Figure 13 - Inner Join

Inner Join will combine all the rows with the same key records from each table. For our example the two datasets will be connected by Bank Cert/FDIC Cert.

Figure 14 – Outer & Inner Join

UPLOADING MULTIPLE DATASETS

CSBS + WIKI Here we will download the two documents discussed in the Downloading External Data Section. This is the CSBS District and State Fips form Wiki. Follow the steps in the Upload Data section for uploading a single file. Refer to

10 | P a g e