Selecting data based on condition

[SCK]

Hi all. I need help in selecting data based on a condition. The condition being that I should not select more than two of the same customer. Below is the input. Please help.

Input:

Name	Amount
A	100
B	40
C	50
D	20
E	60
F	80
G	100
H	90
A	85
A	80
A	100
D	40
D	50
D	20
H	60
H	80
I	100
M	90
R	85
E	80
C	87
D	79
C	86
P	50
H	45
H	30
E	20
F	100
R	150
E	66
A	190
A	250
A	300
A	79
A	86
F	50
F	45
F	30
G	20
H	100
H	150
A	65
A	99
A	87

In the above example - I can choose A but only twice and the amount can be anything for example - A 65 and A 100 or A 99 and A 87.

Thanks

[PhilipMannering · Accepted solution]

Here you could just use the Sample Tool. Pick N=2 (for any selection method) and Group by the column [Name]

[atcodedog05 · Accepted solution]

Hi @SCK 

You can use a sample tool like this

Set it to Pick First 2 rows groupby Name.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Emil_Kos · Accepted solution]

Hi,

I believe the easiest way to achieve this is using the sample tool.

It gives you possibility to group by certain column. In this particular case you need to group by name and pick first 2 rows. 

Good Luck!

[Qiu · Accepted solution]

@SCK 
Sample tools is for this.

[atcodedog05 · Accepted solution]

Guess we all thought alike and posted in seconds interval 😅

[Qiu · Accepted solution]

@Emil_Kos  @atcodedog05  @PhilipMannering 

You guys are unbelievable.😁

[SCK]

All worked perfectly fine. I did not think of the group by method earlier. Thanks for your help. 🙂

[atcodedog05]

Hi @SCK 

Since we all responded at the time with alike solution i would request if you can mark all our posts solution😅

Then again its totally upto you🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂

[atcodedog05]

Thank you for your generosity 🙂 @SCK 

Happy to help 🙂

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂