I've read a lot about these here but seems that the solution that I need is not here.
I have one table with animals and the country of origin concatenated csv like this:
Animal 1 | Norway, China, Perú
Animal 2 | Spain, Argentina, United States
I need to link that with another table where there are regions.
Norway | North Europe
China | Asia
Spain | South Europe
Obviously, I can't link it with the CSV content.
So, I created another table from the same source as the first one but in columns like this.
Animal 1 | Norway
Animal 1 | China
Animal 1 | Perú
Animal 2 | Spain
...
Then I linked the first table with this one (with the ID, not showed here). And also I linked this third table with the country region one.
So, now I need to have a report where I can export the list of animals filtering it by region.
I've created a report with a Table including data from the First table and adding Region filter.
1 - This way the filter is not working as there's no data from the table where the Region is linked.
Solution. I've added data from 2 table to the table, the table result is like this:
Animal 1 | Norway | Norway, China, Perú
Animal 1 | China | Norway, China, Perú
Animal 1 | Perú | Norway, China, Perú
Animal 2 |Spain | Spain, Argentina, United States
...
This way when I filter by region the table changes but I have duplicated Animals and I'm only interested in having Animal 1 and csv countries.
I wonder if it's possible to group by column 1 (Animal1) like MySQL and have something like this:
Animal 1 | Norway | Norway, China, Perú
Animal 2 |Spain | Spain, Argentina, United States
It's not perfect but then I can hide the middle column and check only the other ones.
A long text here... sorry
Thank you for your help.
