I need help in comparing two excel files using studioX.
ExcelA having columns User_id, Email
ExcelB having columns Cust_id, Email
- COmpare ‘User_id’ column of ExcelA with ‘Cust_id’ column of ExcelB, where ‘Email’ column (present in both the excels) is blank.
- Compare ‘User_Id’ and ‘Email’ columns of ExcelA with ‘Cust_id’ and ‘Email’ columns of ExcelB, where ‘Email’ column (present in both excels) is populated in both.
Any input will be appreciated.
Thanks in advance.