Relational load - without matching column names

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • Relational load - without matching column names

      Hi there,

      i´m trying to load an Excel file to a MySql table using ETL extracts and loads, which works fine as long as i have the job create the target table. In that case the columns are named exactly the same as in the source Excel file.

      But after renaming the columns in the database, the first non-match causes an error and the import aborts. So, obviously a relational load requires the target and source field names to match exactly?!

      Does anyone know how to avoid this behavior and use arbitrarily named target columns?

      Your help is appreciated.