Join data

Join the Yellow Trips data with Pickup Taxi Zone Lookup data

  1. Click on the Transform icon, choose Join.

  2. Specify the following information:

    • Node properties tab, Name - Yellow Trips Data + Pickup Zone Lookup

    • Node properties tab, Node Parents

      • Change Schema - Pickup Zone Lookup
      • Filter - Yellow Trip Data

      Glue Jobs

    • Transform properties tab, under the Join conditions, select the following keys:

      • Change Schema - Pickup Zone Lookup - pu_location_id
      • Filter - Yellow Trip Data - pulocationid

      Glue Jobs

  3. Remember to Save your work.