Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Selecting data based on condition

SCK
8 - Asteroid

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:

 

NameAmount
A100
B40
C50
D20
E60
F80
G100
H90
A85
A80
A100
D40
D50
D20
H60
H80
I100
M90
R85
E80
C87
D79
C86
P50
H45
H30
E20
F100
R150
E66
A190
A250
A300
A79
A86
F50
F45
F30
G20
H100
H150
A65
A99
A87

 

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

10 REPLIES 10
Qiu
21 - Polaris
21 - Polaris

@SCK  @atcodedog05 
Thank you all.😁

Labels
Top Solution Authors