How to compare two column (A and B) if another column(C) have value then dont add matched rows

[mashy2]

Hi, I have example excel.
Example.xlsx (23.4 KB)

On sheet Read Input:

if Column B matched with Column A (Order No) on another sheet:

How to let both this column compare and if column C (SID) on sheet Read Input have value, then not replace matched rows

And also if Quantity of Column A (Order No) on Input2 sheet > quantity of Column B(Order No) with value on Column C (SID) then add the leftover quantity on excel row

Expected output:

Can i have idea how to do this?
Thank u so much!!

[arivu96 (Arivazhagan A)]

Hi @mashy2 ,

Can you share the expected output based on your input.

Regards,
Arivu

[mashy2]

hi, i have added my expected output.
The idea is that, if same order no but have SID, then need to minus the quantity. if same order no with no SID, then need to update info and also add leftover quantity of same order no

[mashy2]

its quite complicated, i also dont have any idea on how to minus those order no that have SID.
hoping someone can help me out cause RPA definitely not my forte

[supermanPunch (Arpan)]

@mashy2 , Please do Close this Topic, as we already have the Solution for this in the below Post :

Count duplicate rows of column and compare quantity from another datatable

Hi @mashy2 , Checking the Similar Topic created by you, I was able to get the Input Excel. Hence, I was able to create a Workflow which provides the Output as Required. However, needs confirmation from your end. Check the Workflow Below and Let us know if it satisfies your Requirements : DT_CompareQuantity_AddRows.xaml (10.2 KB)