I'm trying to populate a dropdown filter with a mcatalog search to allow a user to select from a list of dimensions. The search works but the results are returned as a long string without line breaks between the items returned. I've been looking and looking for a solution but can't find anything. So I'm reaching out for help.
|mcatalog values(array_name) AS array_name WHERE index="my_index"
I've tried many many options (eval, rex, table, and so on) to get the results formatted as a list that shows up properly in the dropdown. Thanks in advance.