need help in winsorizing (outlier removal)

alteryx_user

Hi, 

I am trying to remove outliers in the column "value".

Expecting output as in the column "adjusted".

if [Name]="asset"
and
[Value]<"-218.23" then "-218.23"
else
[Value]
endif

if [Name]="asset"
and
[Value]>"520.33" then "520.33"
else
[Value]
endif

Please find the attachment for input.

Appreciate your help

winsor.csv

NickSm

@alteryx_user 

Can be done with a formula tool and the the expressions you've entered here, just have to make sure the fields coming from the .csv are changed to numeric prior to the formula.

Also, to recreate the "Adjusted" column it didn't look like the [Name] field had to be part of the expressison - attaching a workflow that shows both.

RemoveOutliers.yxmd