Sum up from different workflow and outputs

[clara777]

Hi, need some help here as pretty new to alteryx.  i have created 3 outputs since they are from different data sources and it shows in Alteryx as exactly like these now. I need to group them get the variance for  Gross comm vs ledger and Stamp duty vs ledger for both products combined .  Variance  = A + B + Ledger

 It can appear in 2 separate Lines as per below. I tried using join/union but doesnt seem to work, thanks

Output 1

Name	Value
Gross Comm (A)	20
Stamp Duty (A)	50

Output 2

Name	Value
Gross Comm (B)	80
Stamp Duty (B)	50

Output 3

Account	Amount
Gross Comm Ledger (A and B)	-100
Stamp Duty Ledger (A and B)	-110

FINAL OUTPUT

Gross Comm (A)	Gross Comm (B)	Gross Comm Ledger (A and B)	Variance
20	80	-100	0

Stamp Duty (A)	Stamp Duty (B)	Stamp Duty Ledger (A and B)	Variance
50	60	-110	0

[Felipe_Ribeir0 · Accepted solution]

Hi @clara777 ,

Here is a way to build the 2 outputs:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[Emmanuel_G · Accepted solution]

Hi @clara777 ,

Find attached the way of doing this simply.

Mark as solution if it helped please.

[clara777]

Thank you. It was really helpful and worked.

One more question, if I need it to be on the same output, how should i go about it? ie eventually output into 1 excel spreadsheet but in 2 separate rows , one above each other

Thanks!!

[Emmanuel_G]

Hi @clara777 ,

Do you want something like this ?

Please do not hesitate to mark this answer as solution if it helped.