Selecting largest records in a table

anamik72

Please find below an input and an output table. I want output table to include only those rows from input table where Amount is largest for a given Customer. Can you help? Thanks

Customer	Channel	Sub Customer	Amount
111	Channel A	123	$           1,000
111	Channel B	345	$                 10
111	Channel C	456	$                   5
222	Channel A	678	$               780
222	Channel B	345	$               560
222	Channel C	999	$               670

Output
Customer	Channel	Sub Customer	Amount
111	Channel A	123	$           1,000
222	Channel A	678	$               780

Aaron_Harter

Hi @anamik72,

First use a Summarize tool to determine the Max value per Customer, then use a Join to filter the data table for only those records:

 

2020-04-16 join to filter.yxmd