How to display all values in a field?

[NizanCohen]

Hi.

I'm looking to make a table/stats of all fields in a search to display all values inside of each field.

Similar to stats count, but instead of counting the amount of values, I want to display all values inside.

[Manasa_401]

Hello @NizanCohen 

Try this : stats values(*) as *  

OR using a by clause

stats values(*) as * by unique_field

This will give the result as multivalued field.

Thanks

Manasa

[NizanCohen]

Should I keep it as "unique_field"?

Because it returns no results the way you wrote here (I copy pasted it the way it is).

[Manasa_401]

That unique_field is just for reference.

First try |stats values(*) as *

This will give all the data in single row as multivalued fields.

If you have any field in your data by which you can group it then use that field in by clause.

|stats values(*) as * by your_field_name