Power Query - Fill down/up does not work with csv file

[lezawang]

Hi
I have a csv file (see the link below please). When I open a new excel file then Data-->Get Data --> From CVS, it will be loaded to PowerQ editor but the empty cells are blank (nothing inside them, no NULL keyword). When I tried to Trasform-->Fill down/Up nothing changed (the first column was highlighted).

Then what I did, I open it the CSV file and then clicked on Data-->From Table/Range, the table was loaded to Power Query editor and the empty cells in the first column were filled with "null" keyword and Fill-->Down worked file.

Why it did not work when I tried to GetData from CSV? Thank you so much.

text14.csv

drive.google.com

 

[alansidman]

When I downloaded your file, it was a PDF and not a CSV, however, it did come in with empty cells in Column A. What I did was highlight the column in the PQ editor and on the transform tab, replace values. Replace and left the top box blank and put null (with lower case) in the replace box. Now I was able to fill down.

= Table.ReplaceValue(#"Changed Type","",null,Replacer.ReplaceValue,{"Sales Rep"})

 

[lezawang]

When I downloaded your file, it was a PDF and not a CSV, however, it did come in with empty cells in Column A. What I did was highlight the column in the PQ editor and on the transform tab, replace values. Replace and left the top box blank and put null (with lower case) in the replace box. Now I was able to fill down.

= Table.ReplaceValue(#"Changed Type","",null,Replacer.ReplaceValue,{"Sales Rep"})

Thank you, I got it. It is working. But is this a bug in the PQ? why I do not need to do the "Replace with NULL" step if I Get Data from Table? Thank you once again.

 

[alansidman]

Don't know if a bug or just the way things happen with .csv or .pdf files. I usually don't work with either unless it happens in a forum I am assisting. Glad you have it working.

 

[lezawang]

Thank you for your help. I appreciate it.

 

[dof]

Thank you for your help. I appreciate it.

From a text / csv file, it's considered as an empty string, rather than a null. Not a bug, I don't think. You just need to remember that Fill only fills over nulls, so if you don't see null it ain't gonna fill.