Adding values with the same Key (contract number) to compare with the other DT

Help
, ,
1

Hi,

I would like to add values with the same Key (contract number) in “DT0.xlsx” to compare with the other DT (“DT1.xlsx)”, if the summed value for the same contract number is equal, add a column with “checked” in “DT1.xlsx”. Please help!
DT0.xlsx (8.3 KB) DT1.xlsx (8.1 KB)
The output should be likeimage

2

Hi @Siyu_Angela_Kuang
Check this workflow
excel.zip (48.2 KB)

Hope it helps you

Mark it as solution if you got it

Regards

Nived N

Happy Automation

3

Thank you！When viewing your solution, I have a question: why we need to create the dt3?

4

Since u need to find similar similar contract numbers and find the sum of values

What i am doing is using i am allocating to the datatable st3 of one contract type data and summing it all the values and comparing with value of contractno of other datatable

5

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