Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multi Row Formula Issue

rev
7 - Meteor

Hello everyone,

Ran into an issue with alteryx. Still building up skills, hoping someone can help with the below. 

I want to add a column to the below dataset that effectively identifies a threshold using some logic. 

AcctDELTA $
A11,940,549
B621,458
C-6,847
B-19,602
A-2,601,305
B-1,570,860
C8,363,393
B-16,322,719

 

The below is how I would like the threshold to be added. The simple logic being if Abs(Delta) > 50,000 grouped by Acct. 

But i want the count to increase on a specific account if there are more than one. Instead of just identifying, i would like to have a increasing number or alphabet, whatever makes it easier. 

 

 

THRESHOLDAcctDELTA $
1A11,940,549
1B621,458
 C-6,847
 B-19,602
2A-2,601,305
2B-1,570,860
1C8,363,393
3B-16,322,719

 

Any help is highly appreciated. have a good day!!

 

thanks!

2 REPLIES 2
BenMoss
ACE Emeritus
ACE Emeritus

Hi, welcome to the community!

 

I've created a workflow that should bring you to a solution.

 

Firstly I isolated only the records that meet the criteria.

 

I then created an incrimental ID within each account group. Which can be achieved using the multi-row formula tool. I called the field 'ID' and use the syntax...

 

[Row-1:ID]+1

I then added 'acct' as a group by field, meaning it essentially restarts.

 

Finally I union back the data that did not meet the criteria.

 

I hope this helps.

 

Ben

rev
7 - Meteor

Thanks Ben, that was helpful.

Out of curiosity, I wanted to ask if there was a way to do the same with alphabets. 

Instead of incremental numbers, it would be A, B, C etc. 

 

Thanks,

Rev

 

Labels