Choose the row with maximum value after doing the join

[ramii]

Hi,

   I have table 1 containing one column. Lets say hostname with values "A1" and "B1". Table 2 has hostname, application name and risk score. See attached workflow. I want the green rows as output i.e. rows which contain highest severity level for a given hostname, application name combination(See screenshot. need the rows highlighted in green).

Please see the attached workflow and screenshot. 

[andre347]

Attached a solution. I used a sort tool to sort the hostnames from highest to lowest score. Then used a sample to find the first one for each hostname (group by in the sample tool).

Find attached the workflow

[ramii]

your workflow is created in the most recent version of alteryx and I cant open it. Can you please attach a screenshot. specially the configuration you did in the sample tool. 

thanks a lot!

[andre347 · Accepted solution]

Downgraded to 10.5/6 and attached screenshots

[ramii]

Hi,

   So i ran into another problem. If there are two hostnames with same risk scores for different applications, then I need both the rows. Please see screenshot. Please suggest something. 

Thanks,