topic Re: How to Read Array Data from Mongo Collection? in Talend Studio

How to Read Array Data from Mongo Collection?

sudarshank — Fri, 15 Nov 2024 22:24:16 GMT

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!

Re: How to Read Array Data from Mongo Collection?

Anonymous — Thu, 03 Nov 2022 01:02:15 GMT

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.

Re: How to Read Array Data from Mongo Collection?

Roberto72543 — Thu, 03 Nov 2022 04:55:42 GMT

Thanks so much, your suggestion worked for me..

Thanks,

MyHerbalife Products

Re: How to Read Array Data from Mongo Collection?

sudarshank — Thu, 03 Nov 2022 05:47:10 GMT

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

Re: How to Read Array Data from Mongo Collection?

sudarshank — Thu, 03 Nov 2022 09:17:18 GMT

Hi MWoods,

can you share the screen shot of tExtractJSONFieldscomponent. setting?