Skip to main content
Solved

Merge CSV with Different Attribute Names


Forum|alt.badge.img

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.

View original
Did this help you find an answer to your question?

2 replies

erik_jan
Contributor
Forum|alt.badge.img+18
  • Contributor
  • Best Answer
  • July 6, 2018

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.


Forum|alt.badge.img
  • Author
  • July 9, 2018

Thank you! That worked.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings