From comma-separated List To Rows

I would like to set up an INPUT Table and an OUTPUT Table.

Where OUTPUT Table keeps a tally of PlayerName and PlayerScore based on rows from INPUT Table.

But it only counts if user=Admin.

(*Screenshot for reference)
I was able to set up the INPUT Table in such a way that the counter only works if user=Admin.

But I can’t figure out how to make it so that OUTPUT Table tallies all the scores for all players.

Thanks in advance for your help! :smiley:

Dear @Tim_Time,

Welcome to the community!

It’s always recommended to share a dummy version of your doc to make it easy for somebody to understand your logic and suggest a solution ( if possible)

The screenshot doesn’t show what’s under the hood!

Hello @Tim_Time!
I would suggest a change in schema, but for what I can guess you import the info as is.
Check this Coda out to see if it helps to achieve what you want.

2 Likes