Comparing the present data with the previously data from the excel

The data that below is used as a input and in EXCEL AS DATATABLE after one transation i want to check the prevous mail in order to stay log in or not .
image

Note: if the mail is comparatively same in the website the process should continue if not log out the existing and log in with present mail.WITHOUT REMOVE DUPLICATION.

I AM USING EXCEL AS DATA TABLE.SO INEED ONLY ROW TO ROW COMAPRISION

Hi Adithyeshwar_goud,
Please check this demo project with the sollution.
Demo.zip (3.5 KB)

Cheers!

1 Like

If you are using REFramework, you can insert the following logic in the Process Transaction state:

previousEmail = If (TransactionNumber = 1, "", dt_TransactionData(TransactionNumber-2)("username").ToString)

If (dt_TransactionData(TransactionNumber-1)("username").ToString().Equals(previousEmail)) Then
    ' code for same email
Else
   ' code for new email
2 Likes

Hi @Adithyeshwar_goud,

I hope you find the solution for your query. If yes, Make mark it as solution to close the loop.

Cheers!

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