Thanks for your Answer ... View more

Thanks for your response , How to use Curl Command in Execute stream command processor ? please let me know you ahve any thoughts for same ... View more

Thanks for your suggestion . Please direct me any links/information for same ... View more

Hi @Vinicius Higa Murakami Thanks for your time and support . Your solution is help full to me . here we are running on windows machine . I was used below flow but it was not working Getmongo->update attribute->queryrecord->mergecontent-> query record(this was not working) -->putfile flowfile structure(Json file) { projectshortname:AAAA projectid:5885858 caseid:1111 }, { projectshortname:BBBB projectid:5885858 caseid:222222 } query record used below query with prj as ( select projectshortname,projectid,caseid, count(caseid) as cnt FROM FLOWFILE group by projectshortname,projectid,caseid ) select projectshortname,projectid,caseid, cnt, SUM(cnt) OVER () AS total_records from prj order by caseid mergecontent- used for combining all flow files queryrecord: applying query record for the consolidated file but this was not working all the records in the file ... View more

Thanks for your response. . But how to get count of one field from json file. for Example : file has empid,deptid,salary fields , how to get total records and number of employees from each department Apreciate your time and help ... View more

Thanks for your response. . But how to get count of one field from json file. for Example : file has empid,deptid,salary fields , how to get total records and number of employees ? Apreciate your time and help ... View more