CODEWITHSUNDEEP
azureazure-data-factory
user406480
user406480

Reputation: 91

ADF: Table contains comma and I want to output using delimiter text

I need some help with using delimited text as a sink. I have a SQL table and one of the columns contains a comma. However, I want to export the data as a delimited text file using comma as column delimiter.

In my source I am using an inline linked service to my database. Then in my source options I have added my select query statement to select the required data.

I do not want any of the data to have double quotes or any other characters. I can't seem to find a way around this problem. Can anyone help?

Database table example:

Name Age Address Tom 10 100 London Road, London UK

Expected delimited file: Tom,10,100 London Road, London UK

Current output: Tom,10,100 London Road~,London UK

enter image description here

Upvotes: 0

Views: 291

Answers (1)

Abhishek Khandave
Abhishek Khandave

Reputation: 3230

I am able to achieve your expected output using DataFlow activity.

Step1: Select DataFlow activity

enter image description here

Step2: Below is Source SQL Table

enter image description here

Add SQL as Source.

enter image description here

Step3: Use Select activity for mapping.

enter image description here

Step4: Use Sink as CSV file.

enter image description here

enter image description here

Expected Output:

enter image description here

Edit - My Sink Configuration

enter image description here

Upvotes: 1

Related Questions