topic Re: tMap: using List as Column Type in Talend Studio

tMap: using List as Column Type

Anonymous — Sat, 16 Nov 2024 03:34:12 GMT

Hello,

In a tMap component, I want to add a column to the output containing an array of pre-defined strings. So I add a column, set the Type to List, and then add comma-separated strings in the expression editor. I've tried this in various ways, but continue to get errors. And I can't seem to find info about this from searching.

Can someone please tell me how to create the effect of an array as a column in tMap?

Thank you,

Dave

Re: tMap: using List as Column Type

fdenis — Thu, 16 Jan 2020 14:49:35 GMT

list type is String type with a predefined list of content.
use String with a separator not list .
regards

Re: tMap: using List as Column Type

Anonymous — Fri, 17 Jan 2020 20:41:47 GMT

Thank you for your response.

What I really want/need is a JSON array.

I solved my problem by using tWriteJSONField:

https://help.talend.com/reader/Btf8zDsnT4ikhQgFW1plpQ/68ie9Fe1gNc_JNy~7zjIbg

along with this info on how to configure a JSON tree, with info on configuring for an array

https://help.talend.com/reader/LNO9Tqm8svZQklRyXL8OYw/oriVV6vn5bDr9YFigtRMkg

Thanks again for your response