ADF add quotes to all fields

0
votes

I'm trying to do a copy activity in Azure Data Factory, here is how the data looks

Source: Dynamics 365 entity

A(GUID) | B(boolean) | C(string)
04741b89-3d51-ea11-a811-000d3af427b4| False | "some text"

Sink: Azure Blob delimited text file

A(string) | B(string) | C(string)
04741b89-3d51-ea11-a811-000d3af427b4| False | "some text"

I have set the sink mapping in copy activity to string. But the result does not add quotes to the values of A and B field.

Expected result:

"04741b89-3d51-ea11-a811-000d3af427b4"| "False" | "some text"

How can i add quotes to field A and B? enter image description here

2
azureazure-data-factory

2 Answers

0
votes

How can I add quotes to field A and B?

Since you already have double quote in column data, I would suggest you using single quote:

Sink dataset settings: enter image description here

Sink: enter image description here

Then the output file would be like: enter image description here

This will add quote to all the fields, include the first row.

Hope this helps.

0
votes

I was able to solve this by adding a copy activity to json file first and then using the json file to copy to delimited text.

enter image description here