Count duplicate rows of column and compare quantity from another datatable

[mashy2]

Example input:

if the duplicate highlighted rows count is less than the quantity from another datatable. Then have to add rows based on ( A-B, for this example need to add 5 more rows from A)

Desired output: (5 more rows)

Any ways how to achieve this?

[supermanPunch (Arpan)]

Hi @mashy2 ,

Checking the Similar Topic created by you, I was able to get the Input Excel.

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

Hi, I have example excel. Example.xlsx (23.4 KB) On sheet Read Input: [image] if Column B matched with Column A (Order No) on another sheet: [image] 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: [image] Can i have idea how to do t…

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)

[mashy2]

thank u so muchhh