The loop table contains an invalid column name

dczhang1

New OpenSesame user here.

I am trying to use a csv file as the source in a loop but I'm getting the error telling me that "The loop table contains an invalid column name: 'RandNumb' "

Even if I remove the first column, the error just goes to the next variable.

The file is a UTF-8 encoded csv so I have no idea why it won't load properly.

Thanks for the help.

sebastiaan

Hi,

Could you attach the CSV file to this discussion? (Or a similar CSV file that triggers the same problem.) That way I can take a look at what might be wrong.

Cheers,
Sebastiaan

dczhang1

Hello,

Here is the csv file that is triggering the problem.

https://drive.google.com/open?id=1qU8_eWeCK9lsYLCK9tsDHoaA8_9qfp2E

Thanks

sebastiaan

Ah, I see. Your csv file starts with a special unicode character (U+FEFF) called a Byte order mark (BOM). You don't see this (or you may see it as a weird character in a text editor), but it's interpreted as part of the first column name, thus leading to the error message.

The solution would be to save the CSV file without BOM (how you do this depends on your editor), or save it as an xlsx file.

Does that clear things up?