Converting a set to an array

I’m tracking likes in a set [“u1”,“u2”] and trying to reference the names. I’ve tried a direct relation, split text, make array.

Thanks :slight_smile:

What values are you storing in the set? Are you tracking which users have liked an object?

yep, just a flat list of their usernames

I would try:

  • A template column to replace the double quotes character and the square brackets by nothing (don’t put anything on the right.

  • A split text column to split the template column value by a comma (I’m not sure what you mean by reference the names, do you need an array or do you plan to display them?).

1 Like