How to compare the existing mail with previous transaction mail in excel

Help Studio
, , ,
1

i have some login credentials in a excel in which the mails can be same as follows ,in these condition if the mail is already done in previous transaction we need to compare the previous mail with present mail .
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

2

@LOHITH_KUMAR_SAKA

Create a variable or argument and as for step compare if the mail in the variable and the currentmail is same or not…if same then continue if not logout and login again with current

After the comprision at the end save the currentmail to the variable.so that next iteration this mail is compared to next currentmail

Hope this helps

Cheers

3

in your For Each Row reference the index to a variable
image

then you can do an assign

previousrowusername = dt.Rows(indexvariable-1)(“username”).tostring

where dt = your data table variable name

then do an IF to see if CurrentRow(“username”).tostring = previousrowusername or not

4

SORRY, I’m not using for each I’m taking data from in transaction in reframe work in that I’m using excel as data table. Means I’m not using queues I’m using “system.data.datarow” as data type of transaction Item

5

i am also using Excel as Data table and i am unable to compare the previous mail with the current mail and how to assigin the perious mail to variable so tha we can compare with current one .

it will be more helpful if you share a test sequense.

Cheers.

6

@Adithyeshwar_goud

this is what you need to do

image
image510Ă—662 18.1 KB

make sure you iitialize the previousmail variable with string.empty before loop

cheers

7

yes bro ,
i am tring to use excel as a data table instead of using data from orchestrator:
more over i this the proces will be same as in REframework,i am using excel as data table for the first time if there are any mistakes corrcet me.

Cheers.

8

@Adithyeshwar_goud

You can use anything…concept is same…save the row value at the last step so that that can be used in the next iteration before last step to compare and find

Cheers

1 Like
9

i wil try it bro thank you.

1 Like
10

We can compair the previous mail by storing in asset .then we will compare the previous mail from asset and current transaction item.

11

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