I’m trying to merge multiple csv file from a system generated reports daily (some day it is 1 file, if its exceeds 60000, it will split the file with “aa”, “bb”, “cc” in the file name.
The problem I’m facing is to read the first file (only file with header) that have 2 additional rows above the header. With that, I can’t determine the header from this. Which can’t generate data table using the header (starts at row 3).
Looking forward to your support and guidance!
Thanks in advance!