Select the entries which are not repeated earlier.

SekharSai1993

Hi,

I have a requirement to assign the Business roles to users based on the task roles. In the below screenshot, TR - 8 repeated for 4 times and TR - 9 repeated for 2 times. If we assign BR - 4 and BR - 5 to user, there is no need to assign BR - 6 to BR - 9 as the task roles associated to those are already assigned from previous BRs. Is there any way in Alteryx to see if the entry in C column is already repeated in the previous entries for a particular user and mark them as Not required?

Sample Data.xlsx

Yoshiro_Fujimori

I understand you want to avoid assigning multiple TRs to one User.

Then "Sample" tool might come in handy.

With the configuration below, you can pick the first occurrence of [User] - [TR] combination and then you can ignore all the rest.

 (If you use AMP engine, you need to sort the output after Unique tool)

The output:

Unique_yf.yxmd