merge two data sets

[jakushok]

Hi,

I have two sets of data (A and B):
A | B
8 | 6
2 | 6
10 | 8
6 | 8

I want to count and merge into sing table:
val | count_A | count_B
2 | 0 | 1
6 | 1 | 2
8 | 1 | 2
10 | 1 | 0

Thanks.

[somesoni2]

Assuming your current search returns two fields A and B, try something like this

your current search giving fields A and B
| eval temp=1 
| untable temp column val | eval column="count_".column
| chart count over val by column