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

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

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

        Thanks for your advice. In fact it seems to be different between "null" (italic = empty) and "null" when I replace this value.

        In this cas, the fill down option doesn't work either.