Using UID in analysis of Stroop and NBack data

We’re just putting the final touches on a study that involves a total of four rounds of both these tests taken two weeks apart. We’ve added a uid field to match the partcipants’ Qualtrics IDs and other assets we will use, and are trying to work out how to make the connection between the UID and the ParticipantID in the PsyToolit experiment_data folder.

There will be 60 participants so we will end up with a total of 250 data files for analysis in SPSS

I can see the UID we created on appears in the data.xls and we need to bind it to each individual experiment data file using the participantID and the individual output files.

Has anyone tried this and worked out the quickest and ideally automated method?

Any pointers greatly appreciated

Thanks,

JB