Support Questions

Find answers, ask questions, and share your expertise

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


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?


Super Guru

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