i was thinking the field names may not be important as you can use the @ sign to bring in the first field.
Just make sure you specify if there are leading rows to ignore.
@1 as ID
(txt, codepage is 1252, no labels, delimiter is '\t', msq);
attached are the 2 CSV files i tested with.
or how about the following:
use the following statement after your load statement which reads fields and data from the csv file.
rename fields using Mapping_Rename_Table;
where Mapping_Rename_Table is defined (has to be before the load statement from csv file) as
mapping load * inline[
this way you can actually load all the files and not worry about which csv has which variation of student_id field name. in fact, you can add any other fields that you want to rename to the list.
replace % with whatever hide prefix you set. if there isn't one already set, you can set it using the following statement after the standard set statements in the Main script tab
Set hideprefix = '%';