Count duplicate rows of column and compare quantity from another datatable

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?

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)

thank u so muchhh

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.