Question on comparing 2 columns

[jiaqya]

i have 2 columns as below. Please see if you have a way to do this .. thanks..

Requirement is
if col1 = col2 , col1 record stays.
if col1 is not equal to col2, then col2 record stays , col1 record to be removed.

any way of doing this.

col1 col2
1 1
2 2.1
3 3

[vnravikumar · Accepted solution]

Hi

Give a try

| makeresults 
| eval col1=1, col2=1 
| append 
    [| makeresults 
    | eval col1=2, col2=2.1] 
| append 
    [| makeresults 
    | eval col1=3, col2=3] 
| eval compare = if(col1==col2,"true","false") 
| eval col1 = case(compare=="true",col1) 
| eval col2 = case(compare=="false",col2) 
| table col1,col2

[jiaqya]

thanks, what is the entries are not on the same column.

any fix for that ?

[vnravikumar]

Hi

Try this

| makeresults 
| eval col1=1, col2=1 
| append 
    [| makeresults 
    | eval col1=2, col2=2.1] 
| append 
    [| makeresults 
    | eval col1=3, col2=3] 
| eval compare = if(col1==col2,"true","false") 
| eval test = if(compare=="true",col1,col2)

[vnravikumar]

New column test will have the result

[jiaqya]

Thank you Ravi, that works great..

[jiaqya]

Ravi, thanks, think spoke too soon, what if the value to compare is not on the same line .

ex: col1=1 and col2=2 on same line, but 2 is found on 2nd line in col1

| makeresults
| eval col1=1, col2=2
| append
[| makeresults
| eval col1=2, col2=1.1]
| append
[| makeresults
| eval col1=3, col2=3]
| eval compare = if(col1==col2,"true","false")
| eval test = if(compare=="true",col1,col2)