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(256, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Hey Everyone,
I have been trying to read the csv file stored in azure blob using ADF dataflow source
Record in my source file looks like below
This is my dataset configured below
And when I am looking at the data preview from source transformation I can see like below
I am really not getting why its getting into new line.
Any help would be appreciating. thanks
It seems that there are new line characters within your data and since new line characters are also your row delimiter, that might be causing the issue
Hmm... is there a way in ADF that I can maybe remove this new line from the LongDescription column?
Hey,
Please follow the below link:
https://stackoverflow.com/questions/62404320/adf-remove-line-break-from-column
thanks @Nandan Hegde
I tried derived column with replace(LongDescription, "\n","") but it didn't help.
Hi @Rishabh Patil ,
Thank you for posting query in Microsoft Q&A Platform.
As per my understanding on your ask you trying to understand why your data in data preview is not expected and how to over come this issue. Please correct me if it is wrong.
In your dataset configurations you have
/r,/n or /r/nas row delimiter. Meaning, when ever ADF sees new line it treats as new row and try to take that values from starting column. Hence you are seeing your data preview as above.
replace(LongDescription, "\n","") this will not help here as this expression is going to evaluate only on "LongDescription" column what you see in data preview.
For me, it seems your source file data itself is not in proper format. There is not clear delimiter to define new row in file. By seeing data currently in your file its not clear that where exactly the 2nd row should start and where exactly first row is ending.
I will recommend to have source file data corrected with proper column and row delimiters to make this work.
Hope this will help. Please let us know if any further queries.
-----------
Please consider hitting Accept Answer. Accepted answers helps community as well.
Hi @Rishabh Patil ,
Just checking in to see if the above 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 @Rishabh Patil ,
Following to see if the above 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
Thanks you got my issue.
What I did is I have created a Power query in ADF and I used replace which replace carriage return and line feed with space which formatted the column as per required.
But now, my concern is how could I use this Power query as source for my aggregate transformation is data flow? I am trying to check for duplicate rows on one ID column and then need to remove duplicate record.
Any help ?
Hi @Rishabh Patil - You can load power query output data in to some file or table and then from there take that data as source transformation in to data flow and proceed with further transformations.
--------
Please consider hitting Accept Answer. Accepted answers helps community as well.