Compare Data

[Vaishali 11]

I have one excel sheet with almost 5k data, and i want to compare it with a ServiceNow table which has more than 90k records. I wan to check if the table has the names, which are there in the excel and also to check if it's active true or false. How to do this?

[Vaishali 11]

Any suggestions on this?

[Prince Arora · Accepted solution]

@Vaishali 11 ,

Please do one thing:

1) (first way) Firstly pick the first 500/1000 entries from the excel sheet and just go to the table and search in the table like mentioned below (I am taking the example of incident table)

whatever the records you found, you can group it by active true/false

So in the same manner, if you are taking 500 records in first turn, it will take around 10 turns

2) (second way) Export all the 90 k records and make two seperate sheets (first of 5k records and second of 90k records) and apply the formula as mentioned in the Post 

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful based on the Impact.