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.
Question
Many Data files and one column header file
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+26- Contributor
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.