Matching Survey Participants with Y/N by Creating New Column

I have a survey where I generate a list of people who has participated in the survey (Survey Result - Test).

I have also a list of all the staff in the organization (Staff List - Test).

In the ‘Staff List - Test’, I am trying to create a new column D ‘Participated?’ with ‘Y’ if the staff has participated and ‘N’ if the staff has not participated by matching it to ‘Survey Result - Test’.

I have created the robot but there are some errors in execution, please help!

Here are the files:
Main - Test.xaml (10.1 KB) Staff List - Test.xlsx (13.2 KB) Survey Result - Test.xlsx (11.8 KB)

Hi ! Sure, just gonna download the files and I’ll let you know :slight_smile:

I’m back: here is a suggestion of the workflow, let me know if you have more questions :smiley:
Main - Test.xaml (9.8 KB)

1 Like

have a look below:

the case can be done with a Left Join. Within the Join result we can retrieve the participation info if the second Join Column is empty (not participated) or not empty (participated)

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.