Thank you the below seems to work, however, for some reason the search only shows sys1 thru sys5. It does not matter which how many rows I put in the data, it won't show more than 5. | makeresults format=csv data="field1, field2, field3, field4, field4, field5, field6, field7, field8, field9 sys1,10,a,10,c,20,a,10,20 sys2,20,b,10,c,20,a,10,20 sys3,10,c,10,c,20,a,10,20 sys4,30,d,10,c,20,a,10,20 sys5,40,a,10,c,20,a,10,20 sys6,20,c,10,c,20,a,10,20 sys7,50,d,10,c,20,a,10,20 sys8,10,e,10,c,20,a,10,20" | table field1 field2 field3 field4 field5 field6 field7 field8 field9 | transpose header_field=field1| foreach * [eval _row_values = mvappend(_row_values, <<FIELD>>)] | where mvcount(mvdedup(_row_values)) != 1
... View more