Support Questions
Find answers, ask questions, and share your expertise

how can we validate number of documents loaded from mongo collection after get mongo processor load in nifi

how can we validate number of documents loaded from mongo collection after get mongo processor load in nifi

Explorer

Hi

I have requirement to to validate the data load like total number of documents and number of documents for each category in mongo collection after loading by get mongo processor .

I was tried the mentioned option but not working as expected results.Please provide some thought on this issue

Process followed

GetmongoProcessor->updateattribute->queryrecord-->mergecontent->putfile

query record ->SELECT caseid, projectshortname,count(caseid) OVER (PARTITION BY caseid) AS cnt,count(caseid) OVER () AS total_records FROM FLOWFILE

merge content --> used for combining the all the flowfiles which are applied the total casecount and total records but these merged file is not giving proper results.

Please help on this issue