Sorry I modified the question and didn't noticed that keep IPs as part of it. Actually I have events where the field Action is "act" and other events where the same values are inside the field "actResult" but both fiels are never togheter in the same event, I mean, both fields are actually the same. Then, I want to obtain a table with the Action in a column. My real query: index=my_index sourcetype=my_source | eval Action = coalesce("act","actResult") | stats values(createdTime) as EventTime, values(Action) by id | table EventTime Action id But the result is a column named "Action" where all rows have the value "act" I know that the best option is to correct the parsing but I am not the administrator, I just can work with transformation commands.
... View more