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

Assistance needed in Multi Row formula tool.

anonymous008_G
8 - Asteroid

Hi there - Using multi row formula tool how do get expected output from below sample data. I have provided below input data and expected output. 

Please help.

 

INPUT :-

SectorGrossNet
Maturity 137.2824.84
Maturity 348.2748.27
Maturity 559.2671.7
Maturity 770.2595.13
Maturity 1081.24118.56
Long92.23141.99
Maturity 1103.22165.42
Maturity 3114.21188.85
Maturity 5125.2212.28
Maturity 7136.19235.71
Maturity 10147.18259.14
Short158.17282.57
Maturity 1169.16306
Maturity 3180.15329.43
Maturity 5191.14352.86
Maturity 7202.13376.29
Maturity 10213.12399.72

 

EXPECTED OUTPUT :-

 

SectorGrossNetFLAG
Maturity 137.2824.840
Maturity 348.2748.270
Maturity 559.2671.70
Maturity 770.2595.130
Maturity 1081.24118.560
Long92.23141.991
Maturity 1103.22165.421
Maturity 3114.21188.851
Maturity 5125.2212.281
Maturity 7136.19235.711
Maturity 10147.18259.141
Short158.17282.572
Maturity 1169.163062
Maturity 3180.15329.432
Maturity 5191.14352.862
Maturity 7202.13376.292
Maturity 10213.12399.722
3 REPLIES 3
binuacs
21 - Polaris
anonymous008_G
8 - Asteroid

@binuacs -- thank for your help. Your workflow works perfect as expected. However, same expression when I am using in my workflow, it is throwing attached error. What could be the reason. 

 

 

anonymous008_G
8 - Asteroid

@binuacs -- Please ignore above comment. This is resolved, my new field data type was incorrect. after correction result is as expected. Thank you so much.

Labels
Top Solution Authors