CSV file to DataLake Table not converting properly

[romankorchak]

Hi All

I have uploded a CSV file into a DataLake and created a table from it, but table columns values coming up differently from csv values: 
CSV: 

Site,FileUrl,Size,Created,Modified,Name,Author,Editor
SiteName1 , /sites/SiteName1/Shared Documents/Barclays/Contracts/BarclaysContract 2013.pdf , 2.48953819274902 , 08/11/2015 09:41:20 , 08/11/2015 09:41:20 , BarclaysContract 2013.pdf ,  , 
SiteName1 , /sites/SiteName1/Shared Documents/Barclays/Contracts/Barclays Client Contract.pdf , 3.56038379669189 , 08/11/2015 09:41:13 , 08/11/2015 09:41:13 , Barclays Client Contract.pdf ,  , 

DataLake table:

I know some file may contain commas and that could be cosing this issue, but majority are ok

Is there any way to sort it?

Thanks

[v-cboorla-msft]

Hi @romankorchak 

Thanks for using the Microsoft Fabric Community.

I tried to repro the scenario with the same data and didn't find any difficulty in creating a table. Please find the screenshot for reference.

I would suggest you to create a new .csv file and try to create table.

If the issue still persists, please do let us know. Glad to help.

I hope this information helps.

Thank you.

[v-cboorla-msft]

Hi @romankorchak 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thanks.

[v-cboorla-msft]

Hi @romankorchak 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .
If you have any question relating to the current thread, please do let us know and we will try out best to help you.
In case if you have any other question on a different issue, we request you to open a new thread.

Thanks.