topic Re: DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set? in Getting Data In https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114781#M97638 <P>I have gotten around this before by using the table command, so in your example :</P> <PRE><CODE>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 </CODE></PRE> Mon, 10 Nov 2014 15:43:35 GMT russellliss 2014-11-10T15:43:35Z DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set? https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114780#M97637 <P>I have a query that looks like the following:<BR /> index=&lt;&gt; host=&lt;&gt; |rex=&lt;&gt; spath &lt;&gt;|table a,k,h|sort time|append[|dbquery DB "select X,Z,W,P from table_T where &lt;&gt; Order By time_col"]</P> <P>the result set has the following columns:<BR /> a|k|h|P|W|X|Z<BR /> While I expect <BR /> a|k|h|X|Z|W|P</P> <P>How can I get rid of this automatic alphabetical sorting? <BR /> While I run the dbquery alone, it works fine and shows me the expected columns.</P> Mon, 28 Sep 2020 18:08:51 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114780#M97637 pramit46 2020-09-28T18:08:51Z Re: DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set? https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114781#M97638 <P>I have gotten around this before by using the table command, so in your example :</P> <PRE><CODE>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 </CODE></PRE> Mon, 10 Nov 2014 15:43:35 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114781#M97638 russellliss 2014-11-10T15:43:35Z Re: DB Connect: How to prevent append command from sorting columns in alphabetical order in the result set? https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114782#M97639 <P>Thanks a lot @russellliss. This was really helpful</P> Tue, 11 Nov 2014 11:06:21 GMT https://community.splunk.com/t5/Getting-Data-In/DB-Connect-How-to-prevent-append-command-from-sorting-columns-in/m-p/114782#M97639 pramit46 2014-11-11T11:06:21Z