anyone know how do i convert a text value from a source and insert it as a single string in an array into a field in postgresql with type text[] ?
i have tried to format → utils → Text to line item
but it did not work. it converts the text into array of charactors.
i tried using value with delimited l valuehere ], but it gives the same result
Hi
Could you share a screenshot of your Formatter step as that might help us to see if there’s something there that needs tweaking. Don’t forget to obscure any personal/private data from the screenshot.
Could you also confirm the field type in postgreSQL ie what type of data is that field expecting? Thanks!
hi,
this is the filter output
and the insert field
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.