Removing duplicates without effecting other columns

[lledl]

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

WEB	NAME	ROLE
www.tra.sa:808	SAM RON	A1
www.tra.sa:808	DANIEL WATSON	F1
www.tra.sa:808	TOM STUART	A1
www.tra.sa:808	ALEX TASCI	F2
www.tra.sa:808	JACK MAYOR	F1
www.tra.sa:808	TONY UNDERDOWN	F2
www.tra.sa:808	MALEN SKURS	S2
www.tra.sa:912	SAM RON	A1
www.tra.sa:912	DANIEL WATSON	F1
www.tra.sa:912	TOM STUART	A1
www.tra.sa:912	ALEX TASCI	F2
www.tra.sa:912	JACK MAYOR	F1
www.tra.sa:912	TONY UNDERDOWN	F2
www.tra.sa:912	MALEN SKURS	S2
www.tra.sa:66	SAM RON	A1
www.tra.sa:66	DANIEL WATSON	F1
www.tra.sa:66	TOM STUART	A1
www.tra.sa:66	ALEX TASCI	F2
www.tra.sa:66	JACK MAYOR	F1
www.tra.sa:66	TONY UNDERDOWN	F2
www.tra.sa:66	MALEN SKURS	S2

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

WEB	NAME	ROLE
www.tra.sa:808	SAM RON	A1
	DANIEL WATSON	F1
	TOM STUART	A1
	ALEX TASCI	F2
	JACK MAYOR	F1
	TONY UNDERDOWN	F2
	MALEN SKURS	S2
www.tra.sa:912	SAM RON	A1
	DANIEL WATSON	F1
	TOM STUART	A1
	ALEX TASCI	F2
	JACK MAYOR	F1
	TONY UNDERDOWN	F2
	MALEN SKURS	S2
www.tra.sa:66	SAM RON	A1
	DANIEL WATSON	F1
	TOM STUART	A1
	ALEX TASCI	F2
	JACK MAYOR	F1
	TONY UNDERDOWN	F2
	MALEN SKURS	S2

[Federica_FF · Accepted solution]

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

[lledl]

Thanks for the help but could not get it worked. Will be spending more time soon

[patrick_digan · Accepted solution]

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