Skip to main content
  • EN

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


Community Stats

30,108
Posts
114,295
Replies
37,743
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.