This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
There is a column at the end and that is coming empty from the SFTP. But there is an extra comma in the SFTP CSV which is causing this issue.
Can we somehow trim the extra comma(delimiter) which is causing failure in the mapping?
Adding this for your reference to understand my issue.
The complete error message is as follows:
ErrorCode=DelimitedTextMoreColumnsThanDefined,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error found when processing 'Csv/Tsv Format Text' source 'rma_20211022122932_000001.csv' with row number 2: found more columns than expected column count 9.,Source=Microsoft.DataTransfer.Common
Thanks and Regards,
Abhishek
Hi @Abhishek ,
Just checking in to see if the below answer helped. If this answers your query, do click 
and upvote 
for the same. And, if you have any further query do let us know.
Hi @ShaikMaheer-MSFT . I think removing commas this way will be cumbersome so I didn't give it a shot. Because we don't have to remove all characters but comma in the last column when it is empty. I communicated to the other side to correct the CSV files on their end.
Hi @Abhishek ,
Ya if CSV files itself gets correct then we are good I believe.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Did you find the answer to this? I had the same error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 12%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Hi @Abhishek Please go through below post. The issue looks similar:
Error code: DelimitedTextMoreColumnsThanDefined Azure Data Factory:
I have gone through that post but that is not going to help because my last column is empty. How does setting the escape character as a double quote(") will help me?
Hi @Abhishek , Below are the possible causes for this particular error as per documentation, however , if the
column is empty from source side, couldn't you get rid of it in mapping setting?
But it is not necessary to be empty for every row. This means that the column is necessary to be in the schema.
For example if my spreadsheet was like:
Matt | Mary | John | Tom | James
5 | 7 | 6 | 4 | 8
Yes | Yes | | |
The CSV file will look like:
Matt,Mary,John,Tom,James
5,7,6,4,8
Yes,Yes,,,
I don't want the three commas after the second "yes" to be there. Because the pipeline in adf is interpreting as another column in the end. So I want to trim the comma from the end of my file for every row.
Hi try this , might help: