I have many delimited text files of data for each county and one small delimited file with the column headings. The closest I have found to addressing this is this article https://knowledge.safe.com/questions/4831/attribute-header-mapping.html . However this does not seem to work, I also would think there is an easier way I am missing.
Page 1 / 1
Could you read all text files (as text), starting with the file with the column headers and merge the files into one CSV file?
Then after that it would be easy to read the CSV file and do whatever transformation you need to do.
Hope this helps.