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 .
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
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