Pulling out values from eg. row+3 based on specified value

Hi,

as in topic is it possible to pull out values from eg. row+3 based on specified value. (in this example I woullike to pull out the value which is 3 rows below value "Peter")

IN:

Name

Peter

Blue

Green

Pink

Yellow

Peter

Yellow

Red

Purple

Red

Peter

Black

Gray

Orange

Gray

OUT:

New_1

Pink

Purple

Orange

Mutli-Row tool is not good for this case

Thanks !

Datasets

Text Mining

Accepted answers

DataNath

Hey @Wojtek_Dz, I'd say you were on the right lines with the Multi-Row Formula. However, for this case I'd just use it to apply a flag like so:

Which we can then use as a Filter condition to remove the other records:

Following this, you can either leave it or add a select to remove the newly-created [Flag] field.

Filter out Peter + 3.yxmd

All comments

DataNath

Hey @Wojtek_Dz, I'd say you were on the right lines with the Multi-Row Formula. However, for this case I'd just use it to apply a flag like so:

Which we can then use as a Filter condition to remove the other records:

Following this, you can either leave it or add a select to remove the newly-created [Flag] field.

Filter out Peter + 3.yxmd

Wojtek_Dz

😮 thanks @DataNath for this pro-tip

flying008

Hi, @Wojtek_Dz

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703