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

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

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?

1 REPLY 1

Super Guru

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