Need help with a workflow

Hello,

I am trying to figure out how to remove duplicate values on only certain groupings while keeping every other data the same

I tried using sort into muti row formula and IF functions but have run into issues.

Any other solutions?

I included an Excel file with current and goal WS's

Alteryx Help.xlsx

Workflow

Developer

Tips and Tricks

Expression

Accepted answers

binu_acs

@JL-ALTERYX One way of doing this

Amount_0926.yxmd

All comments

gautiergodard

I would recommend solving this using a multi row formula. Attached is a sample workflow that gets you to your goal. You maybe need to adjust based on how your data is grouped and ordered.

***If this provides a solution to your problem, please like this post and mark the issue as resolved!***

MultiRow.yxmd

JL-ALTERYX

I see that worked but what about in cases where there is more data and it wont follow the -2 portion?

I attached an updated file

Alteryx Help.xlsx

binu_acs

@JL-ALTERYX One way of doing this

Amount_0926.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703