Error in the last field name while loading CSV file into Data base by creating table at run time

SURYA SHANMUGAM 1 Reputation point

HI I am loading CSV file into data base with ADF while creating table at run time, the data loadeing works properly, but for ever file the last field name is created with a new line



Azure Database Migration service
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,713 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is to know why last columns shifts out , please do let us know if its not accurate.
    I am pretty confident that the you may have a newline character before the last column and that is what is making the column to shift , if thats the case you can need to remove the new line character .
    We can use the mapping dataflows replace function to replace the newline character . ( you will have to use the derievd column option ) .

    Please do let me if you have any queries.

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

  2. SURYA SHANMUGAM 1 Reputation point

    182767-custodybank-2020504-1.txt please rename tot csv ., it wont allow me to upload csv.


  3. SURYA SHANMUGAM 1 Reputation point

    HI Himanshu, Can you please right-click on the table and generate script create, then you will see there is a new line for the last field, It is visible when you (select *), Select specific field names, you should see the error [Mandate_ID] to [Mandate_ID Newline]

    0 comments No comments