I'm pretty new to Talend, so forgive me if this is obvious. I'm moving data from a web API to a database table. The JSON output from the web API looks like this: elem000 | [elem01, elem02, elem03, ...] elem001 | [elem11, elem12, elem13, ...] ... where the number of elements in each array is arbitrary. I want to iterate over the array to create delimited output like so: elem000 | elem01 elem000 | elem02 elem000 | elem03 ... elem001 | elem11 elem001 | elem12 elem001 | elem13 ...
Hi, For your job requirement, could you please try this solution to see if it works? The work flow should be:web API-->textractJsonField-->tFlowtoIterate-->tIterateToFlow-->t<DB>output. [font=Verdana, Helvetica, Arial, sans-serif]Best regards[/font] [font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font]
