Solved

Merge CSV with Different Attribute Names

Forum|Forum|7 years ago
July 6, 2018
2 replies
17 views

bcrowley10

Hello: I have multiple csv files that have the same number of attributes but some of the attributes have different spellings for the same attributes. Instead of adding multiple csv readers and eventually loading them into one (1) table in Oracle after some subsequent transformations, is there a way to bring the multiple files together and give the attributes the same name for the like fields?

Below is a sample of what the file(s) would look like:

Best answer by erik_jan

I believe with these settings this should work (CSV reader).

I have marked the non-default settings as yellow.

The result would be attributes with names col0, col1 etc.

You need to rename (or map) these to the required output.

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.