Remove Duplicate Rows

[lhbauman24]

Hi,

I have a single file that has the following data:

BU/CoCd	Partner	USD Value
QUTRN	US20	(6,102,059,771.00)
US20	QUTRN	5,962,511,541.78

I created a workflow to put the data on one line and to calculate the difference:

BU/CoCd	Partner	USD Value	Right_BU/CoCd	Right_Partner	Right_USD Value	Difference
QUTRN	US20	(6,102,059,771.00)	US20	QUTRN	5,962,511,541.78	(139,548,229.22)
US20	QUTRN	5,962,511,541.78	QUTRN	US20	(6,102,059,771.00)	(139,548,229.22)

How can remove the duplicate row?  I tried to create a filter but it didn't work.  I only need one of the lines.  How do you suggest I limit the lines?

Thanks in advance.  You guys are all rock stars!!

[BrandonB]

Can you just filter on BU/CoCd = "QUTRN"? Are there only two rows in your final dataset?

[fmvizcaino]

Hi @lhbauman24 ,

Attached is an idea of a solution for your problem. 

I've created a recordID to control the lines and used a filter to remove one of them.

Let me know if this works for you.

Best,

Fernando Vizcaino

[grossal]

Hi @lhbauman24,

the are a couple ways to achieve this, here are my two favorites:

1) Unique Tool

Select the Difference Column in the Unique Tool and you are good to go

2) Sample Tool

You want only one of two lines? Use Sample with "First N rows" and set N = 1.

Regards

Alex

[AbhilashR · Accepted solution]

@lhbauman24 - Not completely understanding the bigger picture of what you are looking to achieve, I built a solution that helps you get one row with the difference in numbers.

Hope this helps.

[lhbauman24]

Thanks everyone.  I had multiple companies not just the 2 in the example.  So this solution seems to have worked.  

[Alfredo_Diniz]

A simple and efficient solution! Thanks, it helped me a lot!