I have this search query which will return a single row of data-
index=xyz | search accountID="1234" instanceName="abcd1" | table curr_x, curr_y, curr_z, op1_x, op1_x, op1_z, op2_x, op2_y, op2_z,...
See more...
I have this search query which will return a single row of data-
index=xyz | search accountID="1234" instanceName="abcd1" | table curr_x, curr_y, curr_z, op1_x, op1_x, op1_z, op2_x, op2_y, op2_z, op3_x, op3_y, op3_z | fields - accouintID, instanceName
and I want to display the resultant row of data in a matrix format like -
Option
x
y
z
current
curr_x
curr_y
curr_z
option_1
op1_x
op1_x
op1_z
option_2
op2_x
op2_y
op2_z
option_3
op3_x
op3_y
op3_z
Please note: Field names are indicative, actual values of the respective fields to be displayed.
Assumption : There will always be only one row for a selected accountID and instanceName
Can someone please help me by letting know how this can be achieved?