We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need Help

anonymous008_G
8 - Asteroid

Hi,

 

Can someone please guide me, how can we add one more record in the below table which would be sum of all FX Forward records just like expected output table.

 

Input table:- 

SectorLongShortGrossNet
FX FORWARD_DKK1.85 1.85-1.85
FX FORWARD_EUR5.2 5.20.1
FX FORWARD_GBP0.81 0.81-0.81
FX FORWARD_NOK1.68 1.681.68
FX FORWARD_PLN0.92 0.920.92

 

Desired output:-

 

SectorLongShortGrossNet
Derivatives10.46010.460.04
FX FORWARD_DKK1.85 1.85-1.85
FX FORWARD_EUR5.2 5.20.1
FX FORWARD_GBP0.81 0.81-0.81
FX FORWARD_NOK1.68 1.681.68
FX FORWARD_PLN0.92 0.920.92
2 REPLIES 2
davidskaife
14 - Magnetar

Hi @anonymous008_G 

 

Here is a way of doing it using the Summarize tool and Union tool - i've created new columns where they might not exist after the Summarize Tool, sorted into the right order, and adjusting the output order from the Union after unioning on position

 

Screenshot 2025-06-19 103743.png

 

Note: you'd have to adjust the workflow if/when data appears in the Shorts column but this should give you enough to go on

anonymous008_G
8 - Asteroid

@davidskaife thanks! this is worked

Labels
Top Solution Authors