I have the following usecase where I am stuck in the implementation:
I have two tables:
Table 1 - Technologies.
I have several entries in it
e.g. Skype, Teams, GoToMeeting, etc.
Table 2 - Disciplines
I have several entries in this table as well
e.g. Chat, Meetings, Planning
Now I have added a new column in table 1, in which I can select the disciplines from table 2:
e.g. Skype - Chat, Meetings
So far so good, I got this far.
What I want to do now:
Counting entries:
I want to add up in a column of table 1 how many disciplines of a technology are stored:
e.g. Skype - Chat, Meetings - 2
What is the correct formula for this?
CSV export:
For export I group table 1 by name. If I now export the CSV I get the following structure:
Colum 1 | Column 2
Skype | Chat, Meetings
But now I need to get the following structure:
Colum 1 | Column 2
Skype | Chat
Skype | Meetings
Is this possible, if yes, how? I have created the dataset so far, and could also provide this dataset via chat or screensharing.
Thank you very much for your support.
Regards, Reto Ulrich