How to insert data correctly with collect command (include fields and values)?

[jordilazo]

Hi,

I'm pretty new to splunk and I have a question.

I am trying to send information from one index to another with the "collect" command.

The problem is that when I send the events to the new index the field and value do not appear as in the old index (they disappear).

I am using this sentence:

index = legacy sourcetype = old_legacy | collect index= mew_legacy

But in the new index i'm not receiving the FIELD->VALUE .

[johnhuang · Accepted solution]

Make sure you define all the fields and values to be indexed.

<base search>
| table field1 field2 field3 ... 
| collect index=<new_index>

[jordilazo]

Thank you. That was what was missing