Forum Discussion
Solved
csv data type
Dear All, I downloaded a CSV file from a finance web site. I have downloaded their CSV files before and use them in Power Query, Excel and so on so I know they are usually fine. The first row...
I have see this happen sometimes when you try to convert it to a whole number and it wont let you. For me, it was because some of the fields really were NOT NUMBERS. Double check your data to make sure that:
1. There really are only numbers in the column
2. If your header repeats itself in the file, make sure you remove that header by filtering it out.
Hi duncanwil
- Just modify your query,
- select your column and verify the data type, in your case it should be "Text" or Any "Type"
- change the type to "Whole Number" => it adds a new tranformation step on the right panel
- Close and apply your changes
And then it should works.
Thank you for your help. It's probably me but I can't think how and why! All is well at the moment!
Thanks for your suggestions anyway.
Duncan