50% of duplicate lines deletion

[Mera1993]

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! 🙂

[fmvizcaino · Accepted solution]

Hi @Mera1993 ,

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

[DavidP]

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

[Mera1993]

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