Apps involved - local MS-excel with 3 columns (Name, dob, Age) and Citrix app(window based with 10 columns( Name, DOB, Age, Address, etc)
Task description - Fetch values from 2 columns (Name,DOB) of excel and compare it with columns(Name,DOB) present in Citrix. If the records match,then column (Age) has to be updated in citrix app based on values from Excel sheet “Age” column because the citrix app is not updated always. Hence we have to run this script to update the data.
I have given the crux of the problem and it would be helpful if you could guide me on this. Please see a sample screenshot. In this case, I have to update the “Age” column in citrix app based on values from “Age” column in Excel
I will read data from excel and iterate for each row, but how can I compare that with Citrix app?