So here is the issue: I've got a spreadsheet that is a list of countries (in column A). Next to each country is a list of journal articles about disasters and displacement within that country. (We're a non-profit making a map of available research on this issue). Each article is another column. So if there is just one article about the country there is just the country name (Col 1) and the article (Col 2). If there are lots of articles then they go is subsequent columns. For example India has about 30 articles.
So I can get the data into Carto DB easy enough. Then I can switch on which columns I want to display data from on my map. If I don't choose any then obviously not articles are displayed when I click a country. If I switch them all on the that looks fine for the one country with the highest number of articles. But for the others it displays an an articles. And then underneath 30 or so rows saying "Article 5 / null" and so on.
So how to I make it so it only displays a column if there is data in it?
أكثر...
So I can get the data into Carto DB easy enough. Then I can switch on which columns I want to display data from on my map. If I don't choose any then obviously not articles are displayed when I click a country. If I switch them all on the that looks fine for the one country with the highest number of articles. But for the others it displays an an articles. And then underneath 30 or so rows saying "Article 5 / null" and so on.
So how to I make it so it only displays a column if there is data in it?
أكثر...