Get Collection Data from Collections in Collections

[AndreKöpplin]

Hello All

Decipher read data from my Table (two rows) in my Document. In Blue Prism I have now a Collection (Document Data), which incl. the Tables (Collection), Rows (Collection) and Fields (Collections) with two Rows with the extracted Table data collection. 

How I can get both Fields.Row(s) (Collection) (see attachment) with my data?

Thanks
Andre

------------------------------
Andre Köpplin
RPA Project Manager
Europe/Wroclaw
------------------------------

[michaeloneil]

Hi @AndreKöpplin

Have you tried writing these out to a new collection? you can set a loop to ​go through the collection and you can either "Drill down" into the data if you know the fields in the embedded collections. You add a loop to go through the main collection, in your case this would be a loop of document data you then add a second loop to go through the rows where the embedded collection is stored. You should have a new collection created to allow to write the values out and you add an add row action then a multiple calculation stage to write each field out to the new collection. You could use this method just to get the values instead if you only need the information and dont need it stored in a new collection. Depending on how you need the data to be stored you might need a separate collection for each collection you need to extract info from or you can just add every row from each embedded collection to a single new collection. 

Please see my example below.



------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------