Excel Reconciliation -URGENT

[mitul_choudhary]

Hi @Nithinkrishna @ermanoj3101

PFA code
i just want to append logic “Identify where part numbers are different and descriptions are same”
ExcelColoringForDataMismatch.zip (501.9 KB)

[mitul_choudhary]

@Nithinkrishna Please help…!!
@ermanoj3101

[Nithinkrishna]

What’s d issue please @mitul_choudhary ?

[mitul_choudhary]

@Nithinkrishna @kumar.varun2
In this code logic is build to Identify out same part number(Column V) having different description(Column W).

But now i want to append logic in this code for vise versa case “Identify where part numbers(Coulmn V) are different and descriptions(Column W) are same”.

ExcelColoringForDataMismatch.zip (501.9 KB)

[mitul_choudhary]

@Nithinkrishna This code was build by u. Kindly help…!!

[Nithinkrishna]

Hey @mitul_choudhary

You need to just swap the fields of the built logic like PN replaced by description.

I think that should help.

Thanks
Nithin

[Nithinkrishna]

Please find the workflow as well.

ExcelColoringForDataMismatch.zip (512.6 KB)

This will do only the current logic which you requested. Please combine the old and this one if required.

Thanks
Nithin

[mitul_choudhary]

Yes have tried it but it’s taking time if u can append that logic on the code attached.

Thanks

[mitul_choudhary]

Please don’t swap please append the logic.