How to Read Array Data from Mongo Collection?

[sudarshank]

How to extract data from array to table format by using tmongoinput.

I have created a job without array is converted in table format but array fields are getting error.

Fields are needed in table format from mycollection - _id,projectid, questionId,questionName,isActive,response, surveyId,surveyName

The collection data in attached file.

Thank you!​

[Anonymous]

Hello,

In the schema settings of tMongoDbInput, you can setup type to "List" for the array field , then use tExtractJSONFields component to extract the child elements of the array field.

e.g.

[Roberto72543]

Thanks so much, your suggestion worked for me..

Thanks,

MyHerbalife Products

[sudarshank]

Hi, Is any setting missing in tmongoDBinput and textractjsonfield. tLogRow returns null value.

 

[sudarshank]

Hi MWoods,

can you share the screen shot of tExtractJSONFieldscomponent. setting?