Any way to get text value from one column based on text value of another column?
I've got a data set that is a series of user and assistant responses. I'm trying to build a table visualization that will show me all user questions where the assistant did not have an answer. My thought was that I could search for the default “no answer” response in the assistant response columns, but am stuck at how to…