Deleting Multiple rows

Hi,

I have an excel file with me. i want to to only keep the first 3 copies of the same word and want to delete all the other. Can this be done? I am sharing the excel file containing the input file and the desired output too. Can anyone please help me with this?

Book1.xlsx

Workflow

Accepted answers

atcodedog05

Hi @Govind_Dileep_G

Here is how you can do it. Use sample tool to keep first 3 rows groupby on the key column.

Workflow:

Hope this helps : )

first 3 rows.yxmd

All comments

atcodedog05

Hi @Govind_Dileep_G

Here is how you can do it. Use sample tool to keep first 3 rows groupby on the key column.

Workflow:

Hope this helps : )

first 3 rows.yxmd

Emil_Kos

Hi @Govind_Dileep_G,

I have a feeling that you have just started with Alteryx.

I would strongly recommend going through this learning path:

https://community.alteryx.com/t5/Learning-Paths/Getting-Started-Learning-Path/ta-p/475117

You will learn some basics and you will build your first workflows in no time!

Besides that sample tool that @atcodedog05 pointed out will work like a dream for you.

atcodedog05

Hi @Govind_Dileep_G

Just adding to @Emil_Kos list.

Here is an interactive lesson on sample tool to get better understanding of usage 🙂

https://community.alteryx.com/t5/Interactive-Lessons/Sampling-Data/ta-p/85807#done

Hope this helps : )

Govind_Dileep_G

thanks you @atcodedog05 and @Emil_Kos . As you sai, i have just started alteryx. but the solution really helped @atcodedog05 . Thanks a lot

atcodedog05

Happy to help : ) @Govind_Dileep_G

Cheers and have a nice day!

Emil_Kos

Hi @Govind_Dileep_G,

I just wanted to let you know that there is a course that is designed for newcomers. It is fine if you will ask questions but if you will invest a time to take this learning path you will be a good track to become Alteryx pro 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703