Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a directory with 15 or so CSV files that all have the exact same field names and structure. When I use the code:
CLReviewData:
LOAD * FROM directory\*.csv (txt, codepage is 1253, embedded labels, delimiter is ',', msq);
It works for most of the tables, but it doesn't work for 2 of the files. Instead, it will import them into CLReviewData-1 and CLReviewData-2.
Any thoughts on what can be causing that?
I found it --- annoying type mismatch where some of the files had year as a number and some had it stored as text.
I found it --- annoying type mismatch where some of the files had year as a number and some had it stored as text.