Hi,

I am a newbie to Mongodb and Pentaho, I am facing trouble to convert my existing RDBMS table to mogodb.
The structure of RDBMS is
user_id,question_id,option_id
12,23,4
12,24,7
12,24,8
12,25,9
I want this to be converted into
{
user_id:12,
questions:[
{question_id:23,Options:[4]},
{question_id:24}, Options:[7,8]},
{question_id:25},Optioins:[9]
]
}
I am using pentaho mongodbOutput, I tried various combinations but none worked. Please help me out here.
Thanks in advance