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 |
Solved! Go to 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
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 |
thank you for help
using your workflow i tried different approach issue got resolved