Hello,
I've been trying to make a dataviz but can't find a way to make it work. I am relatively new to NodeBox. I used the Metallica example with some adjustments to make my dataviz. [I just need this to work to implement it in a more complex one.] While using the original sample file [found under File>Open Examples>Topics>Data Visualization>Zipmap] (with columns "Word" and "Album") everything's fine. Basically in the column "Album" the name of the albums are written in multiple rows; in the column "Word" there is a series of words associated once with the album but found multiple times in the column for there are same words in different albums.
Now passing on to the .csv file I am using, which is about documentaries and countries represented in the documentaries. I have two columns "Title" and "Country". In the column "Country" the name of the countries are written in multiple rows; in the column "Title" there is a series of documentaries associated once with the album but found multiple times in the column for there are same documentaries representing different countries. To me this structure looks very much the same to the sample one; I intended to structure it in the same way.
Now, when I change the csv file in the import csv node with my file, and change the two lookups from "Word" to "Title" and from "Album" to "Country", the resulting visualization is wrong. There are two issues, probably related to each other. First, the titles of the documentaries are _most of the times_ connected to the wrong country, thus it looks kind of random to me. Second, the way the colors are associated to each documentary seems odd: there is an evident repetition of color1, color2, color3 instead of having a more mixed order. Although the lines of the same color do end up in the same country.
Also, the simplified version of my file includes only three countries. I did this after noticing that with the big file (49 countries) I ended up having the same "color-order" issue, plus strangely enough each country had always 3-5 documentaries attached (even though some should have only one and some up to 34 connections). There is an obvious issue here but I cannot understand what I need to do to fix it.
I am attaching six files:
1a. modified version of the Metallica zipmap example
1b. csv for 1a (sample data)
2a. same file as 1b but with my data imported
2b. csv for 2a (my data)
3a. version of the Metallica zipmap example with my large file (the one with 49 countries) imported
3b. csv for 3a
(The original Metallica zipmap file is to be found inside the software so I'm not uploading it.)

I apologize for the long text but I tried to be as clear as possible.
I hope that someone will please help me understanding what is needed to be fixed. I'm available for further explanation if needed!
Thanks to whoever will reply, I'm a little desperate!