Forum Discussion

JdL42's avatar
JdL42
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Any idea why the Fill Down option does not work ?

I have a csv file and the first colum is filled each 6 rows. I try to use the fill down option but nothing appear. Any idea ?
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    No , there is no difference between this two null , when u try to replace empty with null it will consider normal null only. there no italic charcters. check with replace in power Query again and u can . see my previous post image

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

check is there any error on that column 

JdL42's avatar
JdL42
Icon for Advocate I rankAdvocate I
9 years ago

Yes, I've done it but nothing. In fact, I notice something. If I save this CSV file in XLSX, then the field are notice empty (null) and the fill down option work. But in the CSV file, the field are just blank. I check the CSV with an editor and the separation is a tabulation. Could be the problem ?

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    cool dude, 

     

    then we can do one thing , before fill we have to replace balnk with null. then try fill.

     

    Hope i will help u 

    • JdL42's avatar
      JdL42
      Icon for Advocate I rankAdvocate I
      9 years ago

      Yep but any idea to remplace this blank ? I don't find any function ...

      • Baskar's avatar
        Baskar
        Icon for Resident Rockstar rankResident Rockstar
        9 years ago

        Ya sure,

         

        pls look this image .

         

         

         

        let me know any further issue