Talend - Convert String to JSON string array

Question

I am using Talend Studio for data integration to process data. The data are stored in xml file, then are converted to JSON file. One of columns (partners) is a String element delimited by ";" separator.

example : "partner1;partner2;partner3"

expected result : ["partner1","partner2","partner3"]

Is there any Talend functon to do this? or can I use java functions ?

Could you please explain in detail, what exactly you have done so far and the issue you are facing currently — Jim Macaulay
– Jim Macaulay, Commented Aug 16, 2020 at 14:28

Corentin · Accepted Answer · 2020-08-19 08:33:26Z

1

Working with Json data in Talend is quite complicated. You can achieve what you want with Talend components, but workflow is not so simple.

tFileInputXML : extract data from your xml
tNormalize : normalize the column where you have multiple occurences (here I used ";" as a separator). Number of rows in the output is the number of element in your column (in your example : 3)
tMap : I mapped my column, and added a fixed field "loop" for the next component
tWriteJsonField : here you have to use attributes and loops to get an array. see screenshot.

Your question is quite simple, but the resolution is not. If someone has a better way to do it, I am curious to see it.

answered Aug 19, 2020 at 8:33

Corentin

2,5521 gold badge20 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Talend - Convert String to JSON string array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related