From the course: The Data Skills Survival Kit

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Using dates for joins

Using dates for joins

From the course: The Data Skills Survival Kit

Start my 1-month free trial Buy for my team

Using dates for joins

“

- [Instructor] Here's a common scenario: spoiler alert, I have different datasets. The only thing these datasets have in common is the fact that they have information about upcoming events that Explore California will be offering and additional fields that we need for reporting. Explore California has created these great new workshops, like Bike, Hike and Camp, and also Stretch Into Nature, which is a pre-retreat yoga, and then Teaching Nature and Science in the Wild, which is a course offering for teachers. Each of these events have different workshops. The way we support the workshops is we have volunteers throughout the Explore California staff come and join and be a part of the workshop. This volunteer data that we have shows the data that's captured from the volunteer entry form, where employees are able to go in, pick a day, pick a workshop, and assign theirself as a volunteer for that workshop that shows up on the…

Contents