Yes, an app like Excel would be good. But it seems that Cross Tabulation and Pivot Tables calculate the ocurrences in the intersection. What I would like to view in each intersection is a list of note names. After my post, I’ve found a similar discussion, but also on numbers not text, in co-occuring set values across notes, followed up with example code. I have also considered using mysql with Sequel Pro.
Whatever route to follow, the normal csv export described elsewhere is not adequate. I need to get a note repeated for as many times as values in each of its attributes. So for NoteA,Tag1;Tag2,Theme1;Theme2, the exported csv file should have:
NoteA,Tag1,Theme1
NoteA,Tag2,theme1
NoteA,Tag1,Theme2
NoteA,Tag2,theme2
Has a similar iteration been done somewhere else?
My use case: I have around 300 notes for a project, annotated with 50 tags. I would like to view the note names in a matrix, either in TBX or in an external app. First, with tags in both axes, so that I can see which intersections I have missed to plan, and which notes could be merged. Later, tags could be crossed with research questions, research techniques or whatever attributes.