Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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 with a workflow

JL-ALTERYX
6 - Meteoroid

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

3 REPLIES 3
gautiergodard
13 - Pulsar

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!***

JL-ALTERYX
6 - Meteoroid

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

binuacs
21 - Polaris

@JL-ALTERYX One way of doing this

 

binuacs_0-1664221166752.png

 

Labels
Top Solution Authors