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

Hi duncanwil,

 

   this COUNT column contains only numbers? If the answer is yes, did you try to auto-detect the data type?

You can do it like this:

1) Go to "Edit Queries"

2) Go to "Transform"

3) In the "Any column" section select "Detect Data Type"

If the COUNT column data type turns into Any, it means that your column contains different type of values.

 

Let me know.

 

#I'M Not An Expert#

duncanwil's avatar
duncanwil
Frequent Visitor
9 years ago

Thank you for your help.

 

I do what you say and normally it works but just now and again it flares up. It's probably me but I can't think how and why!

 

Thanks for your suggestions anyway.

 

Duncan