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

SURYA SHANMUGAM 1 Reputation point
2022-03-08T12:14:27.62+00:00

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

[#FieldName

]

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
    2022-03-09T23:02:26.657+00:00

    Hello @SURYA SHANMUGAM ,
    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.
    Thanks
    Himanshu


    • 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
    2022-03-14T10:36:01.92+00:00

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

    182814-image.png


  3. SURYA SHANMUGAM 1 Reputation point
    2022-03-24T08:22:10.65+00:00

    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