I'm importing a csv file with about 7 header rows that I do not wish the import to read.
I've used the option
SELECT 'dbr.import.options', 'skip_header', 7;
but this does not seem to work. It only seems to work when the viarable is set to 1 so if I have more than 1 header row I get the following error back:
'Import file does not match the import procedure. Was expecting 21 values, got 1.'
If I delete all but one of the header rows it works without any issues. However this is going to be an automated process so stopping to edit each file will not be practical.
Please can you advise how to get this to work.