How to add column values of IDs and store sum value it in first row of each id in table. Find the attached sample file screenshot.
ID A B C D
1020 2 0 0 1 -add column values in 1 row
1020 1 0 0 1
1020 0 0 0 0
1002 2 4 4 1-add column values in 1 row
1002 0 2 0 1
1002 0 0 1 0
Same goes for 1002 id as well.
Hi @Sonalk ,
Welcome to the UiPath Forum.
Could you please elaborate on the requirement?
if you could present us with some sample data to work with(excel workbook) and an example of the output then we would be in a much better position to assist you.
Hi @ashwin.ashok : Thanks for your reply.
I have provided attachment and explained problem statement and expected output.
Let me onow if you need more information.
Thats an interesting requirement you got there.
@Yoichi and @ppr , would you be so kind as to help us out there?
How about the following sample?
Sample20220921-2.zip (8.8 KB)
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.