50% of duplicate lines deletion

Hi All,

I have just started my journey with Alteryx and I have an issue with removing 50% of duplicated entries.

I mean that for example I have:
a) 8 rows containing letter "A"
b) 6 rows containing letter "B"
c) 4 rows containing letter "C"

What do I want to get?
a) 4 rows containing letter "A"
b) 3 rows containing letter "B"
c) 2 rows containing letter "C"

Could someone please help me with that ? Is it possible? My file has much more columns, but I would like to understand the logic of this?

Many thanks anyone for clue/support in advance! 🙂

Tips and Tricks

Accepted answers

Attached is an example showing how to accomplish that by using the sample tool.

Take a look and let me know if this works for you.

BEst,

Fernando Vizcaino

2020-02-10 50% of duplicate lines deletion.yxmd

All comments

Attached is an example showing how to accomplish that by using the sample tool.

Take a look and let me know if this works for you.

BEst,

Fernando Vizcaino

2020-02-10 50% of duplicate lines deletion.yxmd

If the value of the entire field is A,B or C, you can do it like this, assuming the rows are sorted.

sample tool.png

sample tool.yxmd

Thanks Mate! It worked 🙂 Didnt expect it to be so easy. Didnt know about this sample's functionality 🙂

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703