Compare 2 excel file data

Get Help & Discuss Process Studio
5

Dear Hemanshu,

More thanks for your support…

  1. Failed data, should be written in same excel with sheet2 name as “Mismatch” - Success (MS Excel Writer- Sheet Name)
  2. Failed data, should be written in same excel in sheet2 - Success (MS Excel Writer)
  3. If no Failed data, should not written in same excel(including Header details) in sheet2 - Fail . Its written the Header value. Tried with Filter row, If CC value available then only should write in sheet 2. But written the header value.
  4. Failed data row alone, should be written in red color. if used in same excel, need to written the unmatch data row in different color.

Autosearch and read -
“Get File Names” - Reg Exp (.*.) Received all files. Using MJS check the file name is available or not, instead of directly using Excel Input. Bcoz, if excel not available, will receive the error message. Correct me if am wrong.

If possible also share me the sample workflow of another one request Read mail from inbox