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

[NickSm · Accepted solution]

@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.

[alteryx_user]

@NickSm Thanks for looking into it. You are right. Name field doesn't have to be a part of the expression.