Brand new airtable user here. I’m currently trying to wrangle a podcasting website that has two hundred episodes on it (well, technically, our 200th weekly episode comes out tomorrow). I was able to take a CSV dump out of the Wordpress website I’m using and import it into airtable. One of the things I’m trying to fix is our tagging scheme. However, the CSV dump concatenated the various tags into a single field that is delimited by “|” (pipe) characters. I’d like to first get all the episode tagging into the system, and then start reworking things (I plan to outsource the work of re-tagging stuff in the site, so I plan to use airtable for planning all that out).
So my question is, how would you approach it if you want to easily be able to filter posts by tags (or group by same)? I was thinking of making another table that is simply a list of all tags, and another table that works as the join table between my existing set of posts and tags. Does this seem sane or would you approach it another way?
Also, I’m not intimidated by doing some coding that manipulates the CSV or even generates a different CSV from it, as I’ve been programming forever. Just curious how the community would shape their data if they were me, based on the capabilities of the tool.