Alteryx - Duplicate values based on conditions

[sneha_bhiwagade1]

Hi Team,

Please find the attached sample data with desired output. 

I want to create a log file based on below conditions

1. which contains duplicate marks.

2. marks are duplicate but roll number is different.

Kindly let me know the approach to solve the above problem statement.

Many Thanks in advance!!

[cjaneczko]

I am not following what you are looking to do. What is the condition for the output? Rohan and Pas have duplicate marks but only Rohan is on the output, not Pas? Why Rohan and not Pass?

Input

roll no	name	marks	last name
1	abhi	10	c
1	amit	20	c++
1	raj	30	java
1	rohan	40	android
1	pas	40	python
2	saas	50	oracle
2	aas	20	sql
2	khushi	80	tableau

Output

roll no	name	marks	last name
1	amit	20	c++
1	rohan	40	android
2	aas	20	sql

[sneha_bhiwagade1]

Hi,

@cjaneczko Thank you!!

Either Rohan or Paas can be in the output file but not bot

Because they have the same roll number so only one line will flow in the output file file

[cjaneczko]

If you dont care which one passes through you can use a Unique tool and set the Uniqueness on the Role No and Mark.