Append results in a single line.

[Raging_Rags]

| dbxquery connection="*"  query="select STOREENT_ID,count(*) O_C from table1 "
| appendcols
[| dbxquery connection="*" query="select count(*) P_S_T from table2 "
| join
[| dbxquery connection="*" query="select count(*) P_E_Y from table2"]
|join [dbxquery connection="*" query="select count(*) P_ACTIVE from table2 where status=1"]]

This my sample query, I want all the results in a single line. The value before append prints in a line and after append the values are printed in a new line.

[to4kawa]

| stats values(*) as *

try this.

[Raging_Rags]

Actually its working but 2 rows get mixed up.

[to4kawa]

for mixed up field

| eval fieldname=mvjoin(mixed_up_field,",")