DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set?

[pramit46]

I have a query that looks like the following:
index=<> host=<> |rex=<> spath <>|table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where <> Order By time_col"]

the result set has the following columns:
a|k|h|P|W|X|Z
While I expect
a|k|h|X|Z|W|P

How can I get rid of this automatic alphabetical sorting?
While I run the dbquery alone, it works fine and shows me the expected columns.

[russellliss · Accepted solution]

I have gotten around this before by using the table command, so in your example :

index= host= |rex= spath |table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where  Order By time_col"] | table a,k,h,X,Z,W,P

[pramit46]

Thanks a lot @russellliss. This was really helpful