IF function (To compare excel value)

[victorialim]

HI, I am trying to compare two values across different sheets in excel and to automate sending of email if one value is smaller than the other.
For example,
I have a number in cell A1 in sheet 1 and another number in cell B2 in sheet 2.
I’m looking for UiPath to help me automate sending an email if cell A1 in sheet 1 is smaller than cell B2 in sheet 2. Should I use read range first and assign value followed by flow decision or if function?
I have the ‘Send Outlook Mail Message’ done but I’m stuck at the front part of condition step. Appreciate any help!
Thank you.

[nicortak (Nico)]

Yes, just read the value in A1 and assign it to a variable (value1) and do the same for B2 using read range. Then define the if-condition as if: value1 < value2. Make sure that the value is of type int.

[Palaniyappan (Forum Leader)]

Hi

Hope this thread would help you resolve this

Compare two data tables in different excel files

Hey @Vamshi You can use Following linq to get what you want Scenario is fetch the tags data from excel1 column and find in excel2 in Controller column only. Datatable Final_result = (From x In dt1.AsEnumerable() where (From a In dt1.AsEnumerable() Join b In dt2.AsEnumerable() On a(“Controller”).ToString() Equals b(“Critical tags”).ToString() select a).Contains(x) select x).CopyToDataTable() 726.xlsx (8.9 KB) Book1.xlsx (20.6 KB) comparedt.xaml (11.2 KB) Regards…!! Aksh …

Cheers @victorialim

[victorialim]

Thank you. Can I confirm if the assign step is required? And should i save the variable type as data table before assigning it?
Since it is only a cell value instead of a data table, I’m trying to figure out how should the assign step be filled up. Thanks!