Find unique values

[Ramyasri_1997]

Hi,

I have 1 to 19780 rows in column A. 30800k rows in column b. No i want to remove the identical values from column A and B and display the remaining values

[ShankerV]

@Ramyasri_1997 

Please find the solution below. You will get the output in the U node.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[ShankerV]

Hi @Ramyasri_1997 

Input: 

Output: 

U node

D node (Duplicate)

Many thanks

Shanker V

[ShankerV]

Hi @Ramyasri_1997 

No i want to remove the identical values from column A and B and display the remaining values

Based on the above requirement, I believe you might need the Unique values from Column A and Column B separately.

If yes, the below will help, 

Input:

Output:

Column A unique

Column B unique

Workflow:

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V

[Ramyasri_1997]

Hello Thanks for your time. I have similar values in col A and col B so i want the remaining values in column C. pls find the attachment example.

[Christina_H]

If you want the unique values across both columns, transpose the data first.