Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Getting DataFormat.Error: We couldn't convert to Number

I keep getting the error DataFormat.Error: We couldn't convert to Number. Details: UNK. The columns that I am getting these errors are set as text already. See below.

 

 

Thanks in advance!

 

 
 
Need Help
  • Abduvali's avatar
    Abduvali
    6 years ago
    Just delete step called Changed Type, I assume its there before you unpivot your columns.

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It worked!

     

    Thanks!

    • Abduvali's avatar
      Abduvali
      Skilled Sharer
      6 years ago
      Great stuff mate, glad it helped 👍

      Regards
      Abduvali
  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Can you post your M code? View | Advanced Editor or perhaps a screen shot of your steps?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Is this what you need?