I have two indexes: INDEX1 and INDEX2. In these indexes have the same fields: FIELD1, FIELD2, FIELD3 but they can have different values.
For example:
INDEX1: FIELD1=5, FIELD2=8
INDEX1: FIELD1=5, FIELD2=7
I need to get a table where will be show only fields with different values in different indexes. According the previous example:
|INDEX1|FIELD2=8|
|INDEX2|FIELD2=7|
or something similar
Which field or fields is/are used to join the two indexes so that a comparison between the other fields in the event can be sensibly made?
forget to add these fields in question. I use field @"TIMEIN"
see the answer here for hints