Azure SQL Database
An Azure relational database service.
6,326 questions
XML column splitting in ADF copy activity
![](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(211.20000000000002, 20%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPK%3C/text%3E%3C/svg%3E)
Prapul Kumar Dongari
116
Reputation points
Hi team , I have table in SQL which contains XML column ,while i was copying data from SQL to ADLS (.csv format) the xml column data is getting splitted into new rows.
note : ADF sink dataset settings are as follows
escape character : doublequote
quote character : doublequote
XML column format is shown in screenshot:
please help me with solution
Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator2023-05-02T10:07:27.7033333+00:00 Thank you for posting query in Microsoft Q&A Platform.
It seems your XML data also has double quotes in it. So kindly use different column delimiters and quote characters and try. For example, you can consider using pipe symbol | as column delimiter.
Please let me know how it goes.
-
Prapul Kumar Dongari 116 Reputation points
2023-05-04T06:09:14.0966667+00:00 hi @ShaikMaheer-MSFT we tried using | delimeter but its not working
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2023-05-08T15:53:33.8433333+00:00 Hi Prapul Kumar Dongari, Did you tried with different quote character as well?
-
ShaikMaheer-MSFT 38,546 Reputation points Microsoft Employee Moderator
2023-05-24T06:48:44.9133333+00:00 Hi Prapul Kumar Dongari, Just checking if any updates ? If you found any other work around then kindly feel free to share here. That helps community as well.
-
![](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(25.6, 21%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Javid Ali Khan Lavani 0 Reputation points2023-11-22T11:18:52.0733333+00:00 Hi Maheer,
I am also facing with the similar issue
i have tried by changing the quote character also. Then also it is splitting into two rows i am saving the file in xml format in Data lake.
Sign in to comment
Sign in to answer