same ID based on group

[BRRLL99]

Hi

I have following dataset, if it starts with i| then new id has been assigned

data	id
i|	1
a	1
b	1
c	1
rrr 100- fgb	1
j	1
g	1
i|	2
j	2
k	2
l	2
t	2
101-gh	2

Expected output: based on ID, whenever it contains 100- , then entire id should be marked as same

i would like to do it using multi row formula instead of transpose, my original dataset has 10 million rows

data	id
i|	1	same
a	1	same
b	1	same
c	1	same
rrr 100- fgb	1	same
j	1	same
g	1	same
i|	2
j	2
k	2
l	2
t	2
101-gh	2

[binuacs · Accepted solution]

@BRRLL99 I think join tool would make it much more easier than multi-row tool becuase the key word 100- can any where in the row for a particular gooup that would make it much complex

[BRRLL99]

Sorry my original dataset is different,

100- can be found in same id in multiple rows

if use join it is creating duplicates

data	id
i|	1
a	1
b	1
ctt 100-	1
rrr 100- fgb	1
j	1
gyt 100-	1
i|	2
j	2
k	2
l	2
t	2
101-gh	2

[BRRLL99 · Accepted solution]

thank you for help

using your workflow i tried different approach issue got resolved