Matching Survey Participants with Y/N by Creating New Column

[foppishinc]

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)

[Hiba_B (Hiba Beldi)]

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

[Hiba_B (Hiba Beldi)]

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

[ppr (Peter Preuss)]

@foppishinc
have a look below:

Story line of Join Data Table

Dear innovator’s, All we know that there is a Join Data table activity in UiPath.If we get any matching scenarios with unique value will approach join data table activity instead of filter/loop/array matching activity to find an exact match. Join Data Table: [image] Combines rows from two tables by using values common to each other, according to a Join rule, which is specified in the Join Type property. Sample Table: [image] INNER Join: The INNER JOIN keyword selects records that have m…

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)