Skip to main content

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:

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.


Thank you! That worked.


Reply