Split Arraylist

[Lara_Zuern]

Hello all,

I've only been using Talend Open Studio for Big Data for about two months and I have a question. My data comes from a MongoDB. Each document contains several arrays, which in turn are composed of objects with the same structure (I can still send pictures). I am now trying to split the mother array to write the individual objects in separate rows. The structure of the result should look something like this:

serialnumber | timestamp | object 1 | object 2 etc.

serialnumber2 | timestamp2|object1 etc.

Regards,

Lara

(For Pictures write)

[Anonymous]

@Lara Zürn​ , can you show us an example of document data and what are you expected output?

Regards

Shong

[Lara_Zuern]

Hello Shong,

the first picture shows the original data in the mongodb. Like you can see it is an array with diffirent objects and the objects contain the actual data. The expected output is shown in picture two. I'd like to connect this data to other excel-files in Power BI and for that I have to split it up.