Alteryx - Duplicate values based on conditions

Question

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!!

Example.xlsx

cjaneczko · Answer

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

sneha_bhiwagade1 · Answer

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 · Answer

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 nonamemarkslast name1abhi10c1amit20c++1raj30java1rohan40android1pas40python2saas50oracle2aas20sql2khushi80tableau

Output

roll nonamemarkslast name1amit20c++1rohan40android2aas20sql