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 |
Solved! Go to 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.
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!!
Hi @clara777 ,
Do you want something like this ?
Please do not hesitate to mark this answer as solution if it helped.