How can I convert an array into individual strings?

[juliakhaa]

Hi Professionals!
I work with postgresql, however, I can't implement the functions I know in qlik.
How can I convert an array into individual strings? I have a field that has different id's, they are keys to another table, but I can't associate them in connection with the array, what can help in this situation?

thank you.

[Or · Accepted solution]

Use Subfield() (in script) to break them down into individual rows, and then use the field created by this process to link to the other table.

[juliakhaa]

I wrote this line
SubField(id_operator, ',') as logid
Can you tell me if there are not 2 values in this column, but there is one, won't it be deleted?
And the last question, my given in curly braces, how can I convert them into numbers, the function num does not work in this case for some reason, thanks a lot for the answer)

[Or]

There shouldn't be any problem with just a single value when using Subfield().

I'm not sure what you mean insofar as num and curly braces. You could use PurgeChar(YourString,'{}') if your strings have curly brackets that you want to remove and then format as num(), if that's what you mean?

[juliakhaa]

Yeah, I tried the last one and this worked, thank you, you really helped me