topic Re: Import multiple .csv files where "Number of Header Lines" and "First Data Line" vary by file in Discussions

Import multiple .csv files where "Number of Header Lines" and "First Data Line" vary by file

ashwint27 — Thu, 23 Apr 2026 21:18:46 GMT

We can import multiple files using "Multiple File Import". I have a large number of .csv files to import where the First Header Line is always "1", but the "Number of Header Lines" and consequently, the "First Data Line" may vary between files. For each file, I can potentially use a value in another column to count the "Number of Header Lines", and can also use the first instance of a particular value in that column to denote where the "First Data Line" is, but I am unsure how to script this using JSL. Any help is appreciated.

Re: Import multiple .csv files where "Number of Header Lines" and "First Data Line" vary by file

txnelson — Fri, 24 Apr 2026 02:28:55 GMT

The only way that I have solved this problem was to write some JSL that loops through the target directory, using JMP defaults to read in the first .csv file. Then read through the data table and detecting the row the first real data are found. Once found I set a variable to the row number. I stop the looping and delete the data table. Then I create the JSL that will read the .csv file correctly, and then read in the file. I then repeat the process for each file.

Re: Import multiple .csv files where "Number of Header Lines" and "First Data Line" vary by file

jthi — Fri, 24 Apr 2026 06:09:28 GMT

Sometimes you can also import all the files as raw as possible using multiple file import and then perform the cleanup in the table.