Getting Rid of interchangeable Records

[Ajinkya]

Hello,

I am new to Alteryx and I am facing issue with getting rid of interchangeable records.

Following is the output after performing desired functions in Alteryx,

item	Sales office 1	Sales office 1 Price	SO 2	SO2 Price	Difference (abs)	year
1	Abc	100	BAD	50	50	2013
1	DEF	70	BAD	50	20	2013
1	BAD	50	ABC	100	50	2013
1	DEF	70	ABC	100	30	2013
1	BAD	50	DEF	70	20	2013
1	ABC	100	DEF	70	30	2013

output I want is,

Item	SO1	SO1 Price	So 2	So 2 price	Difference	Year
1	ABc	100	BAD	50	50	2013
1	DEF	70	BAD	50	20	2013
1	ABC	100	DEF	70	30	2013

Also, my table has data for multiple years.

I wand to get rid of unwanted rows here, as i ma taking absolute difference between the products.

Any help is appreciated.

[apathetichell]

filter

[sales office 1 price]-[so2 price]=[difference (abs)]

and the true anchor will have rows where that equation is true.

[Luke_C]

Hi @Ajinkya 

Here's an approach to compare the Sales office names:

1. Add record IDs
2. Transpose by record ID and sales office
3. Sort sales office names alphabetically
4. Summarize/concatenate the sales office values for each record
5. Remove duplicates (this works because we sorted)
6. Join based on record ID, this will cause the duplicates to drop out.