3 Replies Latest reply on Jun 19, 2018 5:22 PM by Alex Kerin

    Combining rows in Tableau Prep

    Alex Kerin

      I'm hoping to achieve this in Tableau Prep:

       

      I have a table that contains driving jobs. I have another table that lists the job ID, a location, a location type (start or end), and the latitude and longitude of the location.

       

      When I join the job table via Job ID to the location table I end up with two rows for each job (a start row and and row)

       

      What I'd like instead is one row per job with a Latitude (start), Latitude (end), Longitude (start), Longitude (end).

       

      Is this possible in Prep?

       

      Thanks.