Hi..
My Keyword , value
ABC A
ABC B
ABC C
XYZ D
These are the values that i have in lookup table..for the values "A","B",and "C" i have to replace with keyword "ABC" ..Now suppose value "A" has 10 occurences , "B" has 5 occurences and "C" has 2 occurences..
When i use the top command with the Mykeyword .it has to show the following stats for me..
say ..
ABC 17 (here 17 is the summation of 10 ,5 and 2 )
XYZ (some value)
how can i do this ??? Is it possible to give a OR condition in lookup table ??
Please help ..
Why not do
... | top myKeyword by value
instead of
.... | top myKeyword
Also, it would be helpful if you showed your exact searches, and possibly a sample of some "real" data. This is a bit abstract and difficult to follow. So my answer is just a guess.