Delimiter Issue

Rohit Kulkarni 731 Reputation points
2021-11-25T10:45:17.213+00:00

Hello Team,

I am passing the data from Azure sql server to Container in CSV format.

CSV Format :

152582-image.png

The column2 value must be :

{"Source": "L0001" Table: "DEPARTMENT" Keys: [{"Column": "CONTEXTID" Value: "1758"} {"Column": "DEPARTMENTID" Value: "482"}]}
The whole Value as to be in column2 .But is taking into different columns3,columns4,column5.

The delimiter i have applied .

152508-image.png

Please advise.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
{count} votes

Accepted answer
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2021-11-25T13:59:53.447+00:00

    Hey,
    Since the data contains the delimiter values (,) :
    152576-image.png

    You need to either add a quote character so that the entire data gets enquoted else use a different file delimiter(value which is not in files)


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.