topic Re: Write embedded array fields to MongoDB in Talend Studio

Write embedded array fields to MongoDB

Anonymous — Fri, 12 Feb 2016 08:29:33 GMT

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?

Re: Write embedded array fields to MongoDB

Anonymous — Mon, 15 Feb 2016 05:25:54 GMT

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.