Forum Discussion

shaazrianlysis's avatar
shaazrianlysis
Regular Visitor
3 years ago

way to fix this auto converting?

hey, when i try to import data from a file with text and numbers - the power query changes the text into numbers and i dont know why... i hope you can help me with this .....the NQ letters turn into nuber in the diagram and also if i execute it and it gets in the power query

the NQ text changes into numbers in the diagram and also if i execute it - in the power query it will be numbers and not the text (NQ). have  nice sunday!

Need Help

3 Replies

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago

    I cannot reproduce your problem

    Please copy/paste some data from the text file you are importing (text, not a screenshot), as well as the M-Code  text from the Advanced Editor in Power Query.

     

    It doesn't make sense to me that `NQ` would get converted into integers, especially different integers.

  • shaazrianlysis's avatar
    shaazrianlysis
    Regular Visitor
    3 years ago

    hey, thank for helping. the m-code:= Csv.Document(File.Contents("C:\chetrem\Short 1\User_Files\BackTesting_Read_files\ReadDataF3.txt"),[Delimiter=",", Columns=8, Encoding=1255, QuoteStyle=QuoteStyle.None])

    it suppose to be for like 25 miliion row if thats matter

    here is a few lines from the data:

    NQ,09/01/2021 16:00:00,0,0,15634,15634.25,69935,15634.25
    NQ,09/01/2021 16:00:01,0,0,15633.75,15634.25,69937,15633.75
    NQ,09/01/2021 16:00:02,0,0,15633.5,15634,69946,15633.5
    NQ,09/01/2021 16:00:03,0,0,15633.5,15633.75,69955,15633.5
    NQ,09/01/2021 16:00:04,0,0,15633.5,15633.75,69957,15633.5
    NQ,09/01/2021 16:00:05,0,0,15633,15633.5,69963,15633.5
    NQ,09/01/2021 16:00:06,0,0,15632.75,15633.25,69970,15632.75
    NQ,09/01/2021 16:00:07,0,0,15632.75,15633.25,69971,15632.75
    NQ,09/01/2021 16:00:08,0,0,15632.75,15633.25,69971,15632.75
    NQ,09/01/2021 16:00:09,0,0,15632,15632.5,69974,15632
    NQ,09/01/2021 16:00:10,0,0,15632.25,15632.75,69978,15632.75
    NQ,09/01/2021 16:00:11,0,0,15632,15632.5,69982,15632
    NQ,09/01/2021 16:00:12,0,0,15632,15632.5,69982,15632

    • ronrsnfld's avatar
      ronrsnfld
      Super User
      3 years ago

      Still cannot reproduce the problem.

      Perhaps, since the file seems to be English and not Hebrew, changing the encoding to 1252 might help.

       

      But I doubt it, since the first two characters are `NQ` for each line (and not some unusual unicode equivalent), and I don't see how, after just the line of code you posted, they would change to different numeric values.

       

      Hopefully someone else will come along with an idea.