Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Select the entries which are not repeated earlier.

SekharSai1993
7 - Meteor

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?

 

SekharSai1993_1-1677898460781.png

 

2 REPLIES 2
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

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.

Yoshiro_Fujimori_0-1677910745735.png

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

Yoshiro_Fujimori_2-1677910990401.png

The output:

Yoshiro_Fujimori_1-1677910854636.png

 

SekharSai1993
7 - Meteor

Thank You So Much Yoshiro for your quick response. This tool worked as expected

Labels
Top Solution Authors