Data filter

[Sooco]

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.

[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

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

[JordanB · Accepted solution]

Hi @Sooco

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

Best,

Jordan Barker

[MarqueeCrew · Accepted solution]

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

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