Looking for row level addition and comment based on the output of the calculation

[cruparelia]

Hello Experts,

I am having data with 10k rows and i want to build a workflow where it sorts the data with amount and CCY. 

CCY	Amount
USD	-15000
USD	15000
EUR	-2000
EUR	2000
GBP	-800
USD	300

It should create additional row between each group based on CCY and Amount and sum up. Along with the Summation, it should populate the comments in the comment column which will give user whether the data is matched if the the total is ZERO and if singleton then the comment will be unmatched.

Below is the sample data for your reference.

CCY	Amount	Comments
USD	-15000	Matched
USD	15000	Matched
	0
EUR	-2000	Matched
EUR	2000	Matched
	0
GBP	-800	Unmatched
USD	300	Unmatched

I am new to Alteryx and not much familiar with Row functions in Alteryx.  Please guide me through the solution on this. Thanking you in advance

[JosephSerpis · Accepted solution]

Hi @cruparelia I mocked up a workflow that produces the output you describe. Let me know what you think?

[ImadZidan · Accepted solution]

Hello @cruparelia ,

Another idea. to give you options.

I hope you find it helpful.

[Milen]

I looking something new and exciting my knowledge