Write embedded array fields to MongoDB

[Anonymous]

I've an entity on my MongoDB like:

{
   "user": "user1",
   "password": "password",
   "clients": ["client1", "client2", "client3"]
}

I've created a tRowGenerator component in order to generate data for {user, password} schema.
By other hand, I've created another tRowGenerator for creating dummy client codes.

Any ideas?

[Anonymous]

Hi 
If you want to merge the columns from different data sources, you can add a key column to each input data, and then do an inner join to get the data like this:
user1;password;client1
user1;password;client2
user1;password;client3

Please refers to this article to learn how to do an inner job. 

on tMongoDBOutput, check the 'Generate json document' box, group by user and password columns, and set clientID column as loop element.