Blob Storage giving different data on data preview adf

Question

Hi,

my activity is -
I am getting this issue where my source is blob file -

on data preview My data is getting changed -

3 commas are getting apended and the value of last 2 columns is moved to next row in just single activity.
what should be the issue?
Any help will be highly appreciated.

Thank you,
Shivani Tyagi

Answer 1

Hi @Shivani Tyagi ,

Thank you for posting query in Microsoft Q&A Platform.

Are you using csv file as source data here? What are settings inside csv file dataset in your case?

It seems your data or dataset settings are little improper which is resulting in data to be appear like this in preview. Your data may have some extra or less delimiters or your dataset may not have column delimiters properly defined.

Kindly recheck also, if possible, feel free to share your data along with screenshots of dataset and implementation so that I can try at my end too and help better.