Removing duplicates without effecting other columns

Question

Hello,

I'm a new member and trying to figure how I can remove duplicates (getting rid of repeated rows) in a specific column

So, I would like to remove the repeated WEB strings (IDs)-without touching NAME and ROLE columns, so I want to make it look like the table below (2nd one). I already tried multi formula tool with an expression of iif(isnull([Row-1:WEB]),[WEB],""), but it is not working as I desired.

(1st table). Original schema

WEBNAMEROLEwww.tra.sa:808SAM RONA1www.tra.sa:808DANIEL WATSONF1www.tra.sa:808TOM STUARTA1www.tra.sa:808ALEX TASCIF2www.tra.sa:808JACK MAYORF1www.tra.sa:808TONY UNDERDOWNF2www.tra.sa:808MALEN SKURSS2www.tra.sa:912SAM RONA1www.tra.sa:912DANIEL WATSONF1www.tra.sa:912TOM STUARTA1www.tra.sa:912ALEX TASCIF2www.tra.sa:912JACK MAYORF1www.tra.sa:912TONY UNDERDOWNF2www.tra.sa:912MALEN SKURSS2www.tra.sa:66SAM RONA1www.tra.sa:66DANIEL WATSONF1www.tra.sa:66TOM STUARTA1www.tra.sa:66ALEX TASCIF2www.tra.sa:66JACK MAYORF1www.tra.sa:66TONY UNDERDOWNF2www.tra.sa:66MALEN SKURSS2

(2nd table)Below is how it should like like...

WEBNAMEROLEwww.tra.sa:808SAM RONA1 DANIEL WATSONF1 TOM STUARTA1 ALEX TASCIF2 JACK MAYORF1 TONY UNDERDOWNF2 MALEN SKURSS2www.tra.sa:912SAM RONA1 DANIEL WATSONF1 TOM STUARTA1 ALEX TASCIF2 JACK MAYORF1 TONY UNDERDOWNF2 MALEN SKURSS2www.tra.sa:66SAM RONA1 DANIEL WATSONF1 TOM STUARTA1 ALEX TASCIF2 JACK MAYORF1 TONY UNDERDOWNF2 MALEN SKURSS2

Federica_FF · Accepted Answer

Hi,

I can't try it on alteryx right now, but I think what you need is a temporary ID that starts again from 1 when the WEB label changes.

Multirow formula: Temporary ID = [Row-1:Temporary ID]+1 grouped by WEB

And then a simple formula that overwrites the WEB column: IF [Temporary ID] = 1 then WEB else "" endif

patrick_digan · Accepted Answer

@Federica_FF's solution appears to work on my end. I've included it as an attachment for @lledl.