topic is there a way to compare two list columns transfer values to another column? in Splunk Search

is there a way to compare two list columns transfer values to another column?

leirga11 — Tue, 13 Feb 2018 05:24:13 GMT

i have events that has columns like this:

date1 date2
01/01/2018 01/01/2018
01/02/2018 01/26/2018
01/03/2018 03/12/2018
01/04/2018 04/1/2018
01/05/2018
01/06/2018

I want to compare them and extract same values to another column. is it possible? thanks in advance.

493669 — Tue, 13 Feb 2018 11:33:46 GMT

try this:

...|table date1 date2 | eval common = if(date1=date2,date1,null())

use if condition to check if it matches and if not matched then its value will be null

leirga11 — Wed, 14 Feb 2018 08:22:48 GMT

I used this command but nothing happened.

493669 — Wed, 14 Feb 2018 08:56:44 GMT

try the updated query