I am having a CSV file and trying to load it into dataflow for the transformation. However, when I checked the preview in the dataflow, my columns values are jumbled and did not appear properly.

I am able to open the CSV file in excel without any issue and below is the sample

Below is the output I am getting in the dataflow

I have other columns and it is getting jumbled

Can anyone advise how to rectify this issue? My csv file size is 257 MB.

CodePudding user response：

Try enabling multiline rows. You can find it in Source Options.