Forum Discussion

duncanwil's avatar
duncanwil
Frequent Visitor
10 years ago
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...
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

duncanwil's avatar
duncanwil
Frequent Visitor
9 years ago

Thanks Adam,

 

It's a while since I posted my request but over the last few days it's happened again. I went through the processes that I always go through but got the problem. I checked here and found that we are all thinking the same things. Still it happened.

 

So I left the problem alone for 24 hours as I thought about it. 

 

In the end, I went back to the query editor and tried one more time and it all came right. I cannot say that I did anything different this final time. Of course, I don't know whether this will happen again either.

 

Thanks for your suggestions anyway.

 

Duncan