I have two datasets:
- A point shapefile of companies (each row/record is a unique company)
- A list of awards given to those companies (each row is a unique award, but since companies can win multiple awards, the same company can exist in multiple rows).
I want to create a Carto map where each point on the map represents one company, but when you click on that company point's pop-up, it shows all the awards that that company has won.
I've tried multiple variations of the "Link second layer" and "Add Columns from Second Dataset" analysis options, but I'm not getting the result I want. I'm thinking that the join created in "Add Columns from Second Dataset" is just a one-to-one join, and it's only joining on the first record it comes across that has a shared company, OR the pop-up itself is restricted to showing only one award.