Data filter

Hi,

I need to show when a price differences from ech other.
See below i have;

Number Price
463.40.008 79.00
463.40.008 79.00
463.40.008 79.00
463.40.009 79.00
463.40.009 109.95
463.40.009 79.00
463.40.009 79.00
463.40.083 39.00
463.40.083 35.00
463.40.013 79.00
463.40.013 79.00
463.40.013 79.00

So the numbers that i want for result are the numbers with "price difference".
From example above the result should be;

463.40.009
463.40.083

Help would be appreciated.

Common Use Cases

Accepted answers

JordanB

Hi @Sooco

Understood. I have updated my workflow to get the number you need.

Best,

Jordan Barker

Unique price differencesV2.yxmd

MarqueeCrew

I might use a SUMMARIZE tool.

Groupby Number
Average Price

Next JOIN the data to the Summarrize output on number=number

FILTER your output where price != avg_price.

You will get all rows output for any number with a different price.

Cheers,
Mark

All comments

JordanB

Hi @Sooco

I have used two unique tool. One on your price field and then another on the number field to give you what you have below.

In my example I get three instances where the prices differ, because your logic below assumes 79:00 is standard and is therefore not included. If this is the case, you can just use a filter tool and say [Price]!=79.00 and then use the unique technique in the attached workflow.

Workflow build in V:10.6

Best,

Jordan Barker

Solutions Consultant

Unique price differences.yxmd

Sooco

Hi JordanB,

The problem is it are several thousend numbers.

Sometimes 1 number has 5 prices (different or not different), sometimes 2 prices (different or not different)

So i cannot use "fixed" filters because the prices veray for each number. In my example i mayby used to much 79.00..

So i only want to see the numbers where prices are different from the same number.

MarqueeCrew

If the summarize calculates the standard deviation, you could filter on it being zero. Zero means everything is the same price, otherwise there is a difference. Just a thought.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703