Remove original and duplicate items from a query

[francesco1g]

Hi, from two columns, in order to create a report, i need to remove the elements that are present twice, not only remove the duplicates (dedup is not useful because it only removes duplicates) but also the original elements, for example:

Table A | Table B

10.10       10.2

10.21       10.32

10.2          10.3

10.60       10.21

Table C (result)

10.10

10.32

10.3

10.60

thanks for your help

[ITWhisperer · Accepted solution]

| eval tableC=mvappend(tableA,tableB)
| stats count by tableC
| where count=1
| fields - count