Using Conditional Statements to Change your Data

Hi everyone,

I am working with one spreadsheet and need to duplicate a row if the Identifier equals the identifier above it. sales rep.PNG

Above is a sample from my data.

What I am trying to do is duplicate the row where [Opp-id]=[Opp-id].

Is there a way to do this in a formula in alteryx or would this be best done in an excel macro?

Thank you,

Nick

Tips and Tricks

Macros

Interface Tools

Accepted answers

SeanAdams

:-) thanks for the ping @MarqueeCrew

@nick22 - I've tackled this slightly differently than Mark, but included both solutions here.

The way that my version works is that it uses Mark's multi-row formula to see whether an oppID is duplicated, and then if so, it adds this row back to the set using a union.

All the configurations and flows are in screenshots (and attachments) below.

Hopefully this solves your problem - if so, would you mind marking as solved - if not, just reply with follow up questions and we'd be glad to iterate with you.

Using Conitional Stmt.yxmd

All comments

MarqueeCrew

@nick22,

I solved this by checking to see if the row above equals the current row (set flag). Then I copied all rows. Then I filtered to keep the first rows plus any that were previously calculated to generate a new row.

Maybe @SeanAdams might improve on this. The generate rows tool could be used with proper conditional logic applied, but I was getting "wrong" results and opted to go for K.I.S.S. to get you to the right results.

Cheers,

Mark

P.S. @nick22, I forgot to include the solution workflow. Now it is attached.

Using Conitional Stmt.yxmd

nick22

@MarqueeCrew

Thank you for getting back to me so quickly. Can you show me how the tools are configured? I'm unsure how to use these tools.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703