I have an Excel file containing 2 columns Prj# and Date. I want to compare each cell of Prj# and each cell of Date. If there is a mismatch I want to write “Row” in different sheet. Please guide me to achieve the same. Here is the sample input and required output.
Hi buddy @Deepak_M
in this case you can use Remove duplicate Rows activity
–use excel application scope and pass the file path as input
–use read range activity and get the output of variable named out_dt which is of type datatable
–use a remove duplicate rows activity and pass the above variable out_dt as input and get the output datatable and mention as out_dt
Cheers @Deepak_M
Thank you @Palaniyappan. I completely forgot about it .
so did that work buddy
Cheers @Deepak_M