Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
romankorchak
Frequent Visitor

CSV file to DataLake Table not converting properly

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:

romankorchak_0-1715177421581.png

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

3 REPLIES 3
v-cboorla-msft
Community Support
Community Support

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.

vcboorlamsft_0-1715242688943.png

vcboorlamsft_2-1715242741185.png

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.

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.

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.

Helpful resources

Announcements
Oct Fabric Update Carousel

Fabric Monthly Update - October 2024

Check out the October 2024 Fabric update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.