If you want to handle it with a load *, that is, you want to pick all the fields in each file even if they are different:
LOAD 0 as dummyfield AutoGenerate 0;
Load * FROM [lib://AttachedFiles/example_data*.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
DROP FIELD dummyfield;
Note there is no For Loop, just a wildcard in the filename.