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
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