Compare 2 columns and Log message

You can try with your data


Log message.xlsx (8.3 KB)
test.xaml (12.9 KB)

hi @Bhushan_Nagaonkar

please check this once

as a sample data i have tested

will we be able to fetch row name also
for eg. “Row Name” is matched\unmatched

hi @Bhushan_Nagaonkar

you can try this as per your requiremnet

Hi @Bhushan_Nagaonkar

Use read range workbook activity to read the excel and store in a datatable. Output - dt_excel.
After that use for each row in datatable activity to iterate the rows in the datatable.
Inside for each Insert the If condition and write the below condition

- Condition -> CurrentRow("Value").ToString.ToLower.Equals(CurrentRow("GoValue").ToString.ToLower)

In then block insert the log message and give the message as “Matched”
In else block insert the log message and give the message as “Unmatched”

Check the below image for better understanding.

Hope it helps!!

I will try and let you guys know. Thankyou
@Shiva_Nikhil @Nguyen_Van_Luong1 @mkankatala

I have updated the workflow image check the image in the above reply for better understanding. @Bhushan_Nagaonkar

I checked it’s working for me.

Thankyou
I wil try it

1 Like

Thankyou. It is working for me but I also need row name

1 Like

Can you say what is the row you want or the row index

You mean row number or row index. @Bhushan_Nagaonkar

If you mean the Input Column value which matched the values.
CurrentRow(“Input”).toString it will give the Input column value.

Hope you understand!!

Hi @Bhushan_Nagaonkar


this will gives you row index can you check the log message which i mentioned in the screenshot

thanks

@Shiva_Nikhil @mkankatala in the above excel that I have provided I also row name such as Payers Name, TaxPayer… So on .

This will give me row name value correct?

1 Like

Okay got it @Bhushan_Nagaonkar

Currentrow(“Input”).toString which gives the value of the Input Column value.
If any queried let me know

Hope you understand!!

Yes absolutely correct @Bhushan_Nagaonkar

@Bhushan_Nagaonkar

you can place in then or else as per need

Currentrow(“Input”).tostring gives you the value of the row from the input column

It is working. Thankyou so much.
@mkankatala @Shiva_Nikhil @Nguyen_Van_Luong1

2 Likes

Happy Automation!! @Bhushan_Nagaonkar

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.