Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
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.
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.
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 |
User | Count |
---|---|
15 | |
7 | |
5 | |
4 | |
3 |