title: using leaflet library to output multiple popup values
body: <p>i am using some data to produce a map with markers in certain places and using the popup function to output multiple values.</p>
  
  <p>The data i am getting is from sql, following is the code for that:</p>
  
  <pre><code>con &lt;- odbcConnect("data", uid = "user", pwd = "password")
  area &lt;- sqlQuery(con, "EXEC sp")
  </code></pre>
  
  <p>The area variable contains 11 rows and 6 column. The 6 columns are: Region (text), Employed(integer), Retired(integer), employed(integer), Longitude (integer)and Latitude(integer).</p>
  
  <p>I am using the longitude and the latitude to make the points on map using the leaflet library. The others i want to be displayed as popup for when the user clicks on the respected points on the map.</p>
  
  <p>The code for how i produced the map and points on them with the popup for each point.</p>
  
  <pre><code>m &lt;- leaflet() %&gt;%
    addTiles() %&gt;%  # Add default OpenStreetMap map tiles
    addMarkers(lng=area$Longitude, lat=area$Latitude, popup=area$Region)
  </code></pre>
  
  <p>The above function works and shows me the popup output with the correct region name on the map. but if i try to change the popup to multiple columns, the map is shown with the points but when i click it doesnt respond to me. </p>
  
  <p>Can someone please tell me how i can output multiple values in the popup.</p>
  
  <p>something like this:</p>
  
  <pre><code>m &lt;- leaflet() %&gt;%
    addTiles() %&gt;%  # Add default OpenStreetMap map tiles
    addMarkers(lng=area$Longitude, lat=area$Latitude, popup=c(area$Region, area$Employed, area$Retired, area$Unemployed))
  </code></pre>
  
  <p>Note: I want the popup to be shown as the following when i click on the point:</p>
  
  <pre><code>Region Name
  Employed: 559
  Retired: 400
  Unemployed: 300
  </code></pre>
  
  <p>Please ak question if you dont understand what i mean as i am still grasping the knowledge of R.</p>
  
  <p>I am doing this on rstudio</p>