Cumulative sum based on the multiple id.

[sriniprad08]

Hi Team,

Hope you are well. I need help. 

I need to sum the values of a column based on the id. Final output column is marked in yellow.

Thanks ,

Sri

[geraldo]

@sriniprad08 

it will always be on 2 lines.
it would be ideal for you to send an example with more sample data

[sriniprad08]

@geraldo  : Thank you . Just attached the sample data.

[caltang]

Hi @sriniprad08 - we need more information. Because based on what you provided, I can only assume that it will always be for the Max line of the 2nd column, and the sum of values of the first column - all provided by the Group of ID. Since this is just an assumption, the workflow I have here may not account for all your needs - please be mindful of this.

 

[sriniprad08]

Hi @caltang ,

Thank you for the solution. Appreciate it. I have attached the updated data.

Please let me know if this looks ok.

[caltang]

Hi @sriniprad08, 

I’ve already attached the workflow for you - replace the text input with your new data and run it. You should get the result you desire. 

If not, you can add a RecordID from the start and to the end, and join back using a Join Tool to get your desired output.

[sriniprad08]

Hi @caltang ,

Thank you.I tried with the  but its giving different results.

sorry may be i am missing something. Do i need to add record id at the end of the flow?

Cheers,

Sri

[caltang]

Yes, you just need to add a RecordID Tool immediately after the Input Tool. 

Then, in the Summarize tool, you need to add the Max RecordID, and you will be able to have your values towards the end. 

Once done, you can perform a Left Outer Join with the main data on the left and the new rows of data on the right. (Join Tool + Union Tool). 

I am currently going to bed soon, try this on your own and you should be able to get it. Otherwise I can help you out tomorrow. 

thanks,

Calvin

[geraldo]

@sriniprad08 

Other example

[sriniprad08]

Hi @geraldo ,

Perfect. Thank you. Great one challenge sorry which i forgot to mention.

There is another column called sub_num. So the flow as to take into consideration num and sub_num.

Please find attached and let me know how to go about it,

Cheers,

Sri