How to get QueryRecord results in a single row rather than in muliple rows?

[#1]

Hi,

am running a select query on the flowfile content using queryRecord processor. However i want the results in single row rather than multiple rows. I tried using Group_concat but queryRecord supports only ANSI SQL standards. Group_Concat is not ANSI SQL command. Any suggestions to get this done?

[#2]

What does your query look like, what are the results, and what would you like to see in the single row/record?