How to make process logic for checking 2 columns data's are matched or not?

[Dorothy_lee]

Hello, all
I’d like to make sequence for compare DATE information.
1st column is Korean Public Holiday and 2nd column is Today Date. I’d like to compare A:A data and B$1$ data and if it is matched, show True or False.
After that, I’ll use If condition…If result is true.then next action…something like that. Could you please help for this? Pls, refer to attached.

holiday_test.xlsx (8.3 KB)
Date_Comparison.xaml (10.6 KB)

[Pravin_Patil1 (Pravin Patil)]

@Dorothy_lee

Refer to below post…It will give you a matching dates data table in return…

Comparing Excel column data of date with system date

@nibir08 Welcome to UiPath Community 1.use Excel Application scope in it use Read Range read the excel and store it in a Data table Dt1. 2.use assign and get system date=datetime.now.toString(“dd/MM/yyyy”) 3.parse the system date DateTime.ParseExact(systemdate,“dd/MM/yyyy”,System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat) 4.use For each row 5.now we need to parse the date column,use Assign DateTime.ParseExact(row(“column name”).ToString(),“MM/dd/yyyy hh:mm:ss”,System.Glob…

[Dorothy_lee]

@Pravin_Patil1
Hello, what does Parse the systemdate…?
I’m facing below error and could find root cause of it…

[NIVED_NAMBIAR (NIVED N)]

Hi @Dorothy_lee can u show the condition in if activitiy which is used ?

[Dorothy_lee]

@NIVED_NAMBIAR Hello, oh… it’s just resolved …!!! Thank you for asking
Used following condition ! row(“KR Holiday”).ToString=systemdate

[Dorothy_lee]

@Pravin_Patil1
Thank you!! It’s working

[Pravin_Patil1 (Pravin Patil)]

Great…All the best…

[Dorothy_lee]

@NIVED_NAMBIAR
Could you please recommend any activities for counting Match result?
I’d like to count up when Match result is existed than use IF condition .

[NIVED_NAMBIAR (NIVED N)]

Hi @Dorothy_lee
i am not cleared with your query

can u explain a little well?

[Dorothy_lee]

@NIVED_NAMBIAR
Sorry for lack of information!
Currently, I’m checking whether today date is matched with Excel A1:A32 data as below.
It’s checking each row one by one and shows Match or No Matach

But the final goal is if Robot finds even 1 match result, I’d like to proceed next action. If there is no Match result than do others
I’m thinking that if save data with Count(Match data) and if count >0 than do something , if count =0 do others.
Could you please provide some advise…?

[NIVED_NAMBIAR (NIVED N)]

In that sequence where the message box display Match, u can put ur action which need to be done for matching

[Dorothy_lee]

@NIVED_NAMBIAR but the problem is is show the result 32 times … It’s checking each low. It means it’s rooping 32 times. Isn’t it ?

[NIVED_NAMBIAR (NIVED N)]

Yes @Dorothy_lee

When u are putting sequence in the matches , then it will execute whenever it meets the condition