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.
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
I used this command but nothing happened.
try the updated query