I need help in creating a script to compare two different excel sheets with almost same data.
We have a report in which all members of an application are saved with their IDs, Last name, First name, Email ID, Roles and etc… fields.
every month several users gets added to it and also removed from this list. So we have to compare them with 2 conditions. Checking all users from OldFile with their User ID in Column A - if
Condition One - Check OldFileUsers with NewFile and if OldFileUser is not in the NewFile then Show them as Terminated Users.
Condition Two - Check NewFileUser with OldFile and if NewFileUser is not in the OldFile then Show them as New User.
with the help of PS we need to give a path and it will pick the latest 2 files and compare them automatically.
Can you please help me to find the solution, i am in the very beginning stage of PS and don’t have scripting background.
Thanks all in advance.