sort column based on dynamic parameters

[krishman23]

My table has variable columns size as
Id, description, detail1, detail2, detail3, detail4, price1, price2, price3, price4,

here detail has price related to the number at the end
some row may have 1 details and some may have 2 or more, but will be in detail - price pair

I want my table in format
id, description, detail1, price1, detail2, price2 ...

[somesoni2]

Are the number suffix on details* and price* columns fixed?

[niketn]

@krishman23, please add the following three pipes to your existing search and see:

 <yourCurrentSearchWithOutputTable>
|  rename "detail*" as "*detail", "price*" as "*price"
|  table Id description 1* 2* 3* 4*
|  rename "*detail" as "detail*", "*price" as "price*"

Following is a run anywhere example:

|  makeresults
|  eval _raw="Id=2327163, description=\"some desc\", detail1=\"detail 1\", detail2=\"deatil 2\", detail3=\"detail 3\", detail4=\"detail 4\", price1=\"price 1\", price2=\"price 2\", price3=\"price 3\", price4=\"price 4\""
|  KV
|  fields - _*
|  rename "detail*" as "*detail", "price*" as "*price"
|  table Id description 1* 2* 3* 4*
|  rename "*detail" as "detail*", "*price" as "price*"

PS: If you are using some transforming command/s to arrive to the sequence of fields as in your question, do share your query for us to see if this sequence of columns can be handled before showing the above results.

[krishman23]

Two things that are weird,
1. In " | table Id description 1* 2* 3* 4* " : I want numbers to be added dynamically
2. In "| rename "detail" as "detail", "price" as "price" " : ruins the table format an get back to same old format.

[niketn]

Can you just use the following table pipe in second last command and remove the final rename?

|  table Id description *

Also while posting code use the code button (i.e. 101010) or shortcut key Ctrl+K to ensure that special character does not escape.