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
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.
Check out the October 2024 Fabric update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |