mashy2
(mashy2)
March 30, 2022, 3:57am
1
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.
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)
system
(system)
Closed
April 2, 2022, 6:31am
4
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.