How to change the order of the fields reading from input look up

[john]

Hi,

Iam using external python script to write resultset to a csv file.Splunk reading columns in alphabetical order.In my case i want to see a particular filed as first column in table.How i can make it.

eg MyResult.csv
s,b,k,a,h
this is the order of fields how my script writing resultset to the csv file

Splunk Reading like this order(alphabetical order):
a,b,h,k,s

I want splunk to read the same order how my script writing data ie(s,b,k,a,h
).Please guide me how to do this.

[Ayn]

You can change the order of the fields that are returned using either the fields or the table command.

| inputlookup mylookup.csv | fields s,b,k,a,h
| inputlookup mylookup.csv | table s,b,k,a,h