Hi all,
I have .csv file with the multiple columns. But only one will be used to compare results, name of that column is exampleIP.
My goal is to compare ip address from that column with the column client.ipaddress from index=blah. If it matches, output new column: Match with the results of Yes or No.
exampleip
--------------
1.1.1.1
2.2.2.2
3.3.3.3
index=blah
| table client.ipaddress
2.2.2.2
3.3.3.3
desired output
|table exampleip, client.ipaddress, match
---------
1.1.1.1 | | No
2.2.2.2 | 2.2.2.2 | yes
3.3.3.3 | 3.3.3.3 | yes
I have already tried to apply different answers from similar subjects but no luck.
Also, is there a way to add other columns from index=blah in the end table result?
Thanks all in advance
... View more