need help in winsorizing (outlier removal)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Developer
- Expression
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NickSm Thanks for looking into it. You are right. Name field doesn't have to be a part of the expression.